Table	Rows	Columns	% Missing (max col)	% Duplicates
customer	30	19	100.00	3.33
employee_privileges	1	3	0.00	0.00
employees	9	19	100.00	0.00
inventory_transaction_types	4	3	0.00	0.00
inventory_transactions	102	10	100.00	0.00
invoices	35	8	100.00	0.00
order_details	58	11	100.00	0.00
order_details_status	6	3	0.00	0.00
orders	48	21	100.00	0.00
orders_status	4	3	0.00	0.00
orders_tax_status	2	3	0.00	0.00
privileges	1	3	0.00	0.00
products	45	15	100.00	0.00
purchase_order_details	55	9	21.82	0.00
purchase_order_status	4	3	0.00	0.00
purchase_orders	28	17	100.00	0.00
sales_reports	5	6	0.00	0.00
shippers	3	19	100.00	0.00
strings	62	3	0.00	0.00
suppliers	10	19	100.00	0.00

Number of variables	19
Number of observations	30
Missing cells	150
Missing cells (%)	26.3%
Total size in memory	28.8 KiB
Average record size in memory	982.8 B

Numeric	1
Text	13
Unsupported	5

Analysis started	2025-10-30 16:47:01.998771
Analysis finished	2025-10-30 16:47:02.138495
Duration	0.14 seconds
Software version	ydata-profiling vv4.17.0
Download configuration	config.json

Standard deviation	8.748333175
Coefficient of variation (CV)	0.6019495304
Kurtosis	-1.225719021
Mean	14.53333333
Median Absolute Deviation (MAD)	7.5
Skewness	0.02021290968
Sum	436
Variance	76.53333333
Monotonicity	Not monotonic

Value	Count	Frequency (%)
1	2	6.7%
19	1	3.3%
16	1	3.3%
14	1	3.3%
3	1	3.3%
26	1	3.3%
11	1	3.3%
15	1	3.3%
7	1	3.3%
25	1	3.3%
Other values (19)	19	63.3%

Value	Count	Frequency (%)
1	2	6.7%
2	1	3.3%
3	1	3.3%
4	1	3.3%
5	1	3.3%

Value	Count	Frequency (%)
29	1	3.3%
28	1	3.3%
27	1	3.3%
26	1	3.3%
25	1	3.3%

Max length	10
Median length	9
Mean length	9.1
Min length	9

Total characters	273
Distinct characters	33
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

Unique	28 ?
Unique (%)	93.3%

1st row	Company C
2nd row	Company S
3rd row	Company P
4th row	Company N
5th row	Company CC

Value	Count	Frequency (%)
company	30	50.0%
a	2	3.3%
s	1	1.7%
p	1	1.7%
n	1	1.7%
c	1	1.7%
z	1	1.7%
k	1	1.7%
o	1	1.7%
g	1	1.7%
Other values (20)	20	33.3%

Value	Count	Frequency (%)
C	33	12.1%
o	30	11.0%
m	30	11.0%
p	30	11.0%
a	30	11.0%
n	30	11.0%
y	30	11.0%
	30	11.0%
A	4	1.5%
B	3	1.1%
Other values (23)	23	8.4%

Value	Count	Frequency (%)
(unknown)	273	100.0%

Value	Count	Frequency (%)
C	33	12.1%
o	30	11.0%
m	30	11.0%
p	30	11.0%
a	30	11.0%
n	30	11.0%
y	30	11.0%
	30	11.0%
A	4	1.5%
B	3	1.1%
Other values (23)	23	8.4%

Value	Count	Frequency (%)
(unknown)	273	100.0%

Value	Count	Frequency (%)
C	33	12.1%
o	30	11.0%
m	30	11.0%
p	30	11.0%
a	30	11.0%
n	30	11.0%
y	30	11.0%
	30	11.0%
A	4	1.5%
B	3	1.1%
Other values (23)	23	8.4%

Value	Count	Frequency (%)
(unknown)	273	100.0%

Value	Count	Frequency (%)
C	33	12.1%
o	30	11.0%
m	30	11.0%
p	30	11.0%
a	30	11.0%
n	30	11.0%
y	30	11.0%
	30	11.0%
A	4	1.5%
B	3	1.1%
Other values (23)	23	8.4%

Max length	16
Median length	11.5
Mean length	6.566666667
Min length	2

Total characters	197
Distinct characters	42
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

Unique	26 ?
Unique (%)	86.7%

1st row	Axen
2nd row	Eggerer
3rd row	Goldschmidt
4th row	Grilo
5th row	Lee

Value	Count	Frequency (%)
lee	2	6.2%
bedecs	2	6.2%
goldschmidt	1	3.1%
axen	1	3.1%
grilo	1	3.1%
liu	1	3.1%
krschne	1	3.1%
kupkova	1	3.1%
xie	1	3.1%
rodman	1	3.1%
Other values (20)	20	62.5%

Value	Count	Frequency (%)
e	25	12.7%
a	15	7.6%
n	13	6.6%
r	12	6.1%
o	12	6.1%
s	12	6.1%
i	10	5.1%
d	9	4.6%
l	8	4.1%
c	8	4.1%
Other values (32)	73	37.1%

Value	Count	Frequency (%)
(unknown)	197	100.0%

Value	Count	Frequency (%)
e	25	12.7%
a	15	7.6%
n	13	6.6%
r	12	6.1%
o	12	6.1%
s	12	6.1%
i	10	5.1%
d	9	4.6%
l	8	4.1%
c	8	4.1%
Other values (32)	73	37.1%

Value	Count	Frequency (%)
(unknown)	197	100.0%

Value	Count	Frequency (%)
e	25	12.7%
a	15	7.6%
n	13	6.6%
r	12	6.1%
o	12	6.1%
s	12	6.1%
i	10	5.1%
d	9	4.6%
l	8	4.1%
c	8	4.1%
Other values (32)	73	37.1%

Value	Count	Frequency (%)
(unknown)	197	100.0%

Value	Count	Frequency (%)
e	25	12.7%
a	15	7.6%
n	13	6.6%
r	12	6.1%
o	12	6.1%
s	12	6.1%
i	10	5.1%
d	9	4.6%
l	8	4.1%
c	8	4.1%
Other values (32)	73	37.1%

Max length	13
Median length	8
Mean length	6.566666667
Min length	3

Total characters	197
Distinct characters	39
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

Unique	26 ?
Unique (%)	86.7%

1st row	Thomas
2nd row	Alexander
3rd row	Daniel
4th row	Carlos
5th row	Soo Jung

Value	Count	Frequency (%)
john	2	6.2%
anna	2	6.2%
daniel	1	3.1%
thomas	1	3.1%
carlos	1	3.1%
soo	1	3.1%
jung	1	3.1%
peter	1	3.1%
run	1	3.1%
helena	1	3.1%
Other values (20)	20	62.5%

Value	Count	Frequency (%)
n	28	14.2%
a	22	11.2%
e	19	9.6%
i	14	7.1%
r	13	6.6%
o	12	6.1%
h	9	4.6%
l	8	4.1%
t	7	3.6%
A	6	3.0%
Other values (29)	59	29.9%

Value	Count	Frequency (%)
(unknown)	197	100.0%

Value	Count	Frequency (%)
n	28	14.2%
a	22	11.2%
e	19	9.6%
i	14	7.1%
r	13	6.6%
o	12	6.1%
h	9	4.6%
l	8	4.1%
t	7	3.6%
A	6	3.0%
Other values (29)	59	29.9%

Value	Count	Frequency (%)
(unknown)	197	100.0%

Value	Count	Frequency (%)
n	28	14.2%
a	22	11.2%
e	19	9.6%
i	14	7.1%
r	13	6.6%
o	12	6.1%
h	9	4.6%
l	8	4.1%
t	7	3.6%
A	6	3.0%
Other values (29)	59	29.9%

Value	Count	Frequency (%)
(unknown)	197	100.0%

Overview

Brought to you by YData

Dataset statistics
Number of variables 3
Number of observations 1
Missing cells 0
Missing cells (%) 0.0%
Total size in memory 222.0 B
Average record size in memory 222.0 B

Variable types
Numeric 2
Text 1

Alerts

`employee_id` has constant value "2"	Constant
`privilege_id` has constant value "2"	Constant
`__table_name__` has constant value "employee_privileges"	Constant
`employee_id` has unique values	Unique
`privilege_id` has unique values	Unique
`__table_name__` has unique values	Unique

Reproduction
Analysis started 2025-10-30 16:47:06.470150
Analysis finished 2025-10-30 16:47:06.519499
Duration 0.05 seconds
Software version ydata-profiling vv4.17.0
Download configuration config.json

employee_id
Real number (ℝ)

Constant Unique

Distinct	1
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2

Minimum	2
Maximum	2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	137.0 B

Quantile statistics
Minimum 2
5-th percentile 2
Q1 2
median 2
Q3 2
95-th percentile 2
Maximum 2
Range 0
Interquartile range (IQR) 0

Descriptive statistics
Histogram with fixed size bins (bins=1)
Standard deviation
Coefficient of variation (CV)
Kurtosis
Mean 2

Median Absolute Deviation (MAD) 0

Skewness
Sum 2

Variance
Monotonicity Strictly increasing

Value Count Frequency (%)
2 1
100.0%

Value	Count	Frequency (%)
2	1	100.0%

Value	Count	Frequency (%)
2	1	100.0%

privilege_id
Real number (ℝ)

Constant Unique

Distinct	1
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2

Minimum	2
Maximum	2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	137.0 B

Quantile statistics
Minimum 2
5-th percentile 2
Q1 2
median 2
Q3 2
95-th percentile 2
Maximum 2
Range 0
Interquartile range (IQR) 0

Value	Count	Frequency (%)
2	1	100.0%

Value	Count	Frequency (%)
2	1	100.0%

__table_name__
Text

Constant Unique

Distinct	1
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	204.0 B

Length
Max length 19
Median length 19
Mean length 19
Min length 19

Characters and Unicode
Total characters 19
Distinct characters 12
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 1 ?
Unique (%) 100.0%

Sample
1st row employee_privileges

Value	Count	Frequency (%)
employee_privileges	1	100.0%

Most occurring characters

Value	Count	Frequency (%)
e	5	26.3%
p	2	10.5%
l	2	10.5%
i	2	10.5%
m	1	5.3%
o	1	5.3%
_	1	5.3%
y	1	5.3%
r	1	5.3%
v	1	5.3%
Other values (2)	2	10.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	19	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	5	26.3%
p	2	10.5%
l	2	10.5%
i	2	10.5%
m	1	5.3%
o	1	5.3%
_	1	5.3%
y	1	5.3%
r	1	5.3%
v	1	5.3%
Other values (2)	2	10.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	19	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	5	26.3%
p	2	10.5%
l	2	10.5%
i	2	10.5%
m	1	5.3%
o	1	5.3%
_	1	5.3%
y	1	5.3%
r	1	5.3%
v	1	5.3%
Other values (2)	2	10.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	19	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	5	26.3%
p	2	10.5%
l	2	10.5%
i	2	10.5%
m	1	5.3%
o	1	5.3%
_	1	5.3%
y	1	5.3%
r	1	5.3%
v	1	5.3%
Other values (2)	2	10.5%

Table: employees

Profile: employees

Overview

Brought to you by YData

Dataset statistics
Number of variables 19
Number of observations 9
Missing cells 12
Missing cells (%) 7.0%
Total size in memory 11.1 KiB
Average record size in memory 1.2 KiB

Variable types
Numeric 1
Text 17
Unsupported 1

Alerts

`company` has constant value "Northwind Traders"	Constant
`business_phone` has constant value "(123)555-0100"	Constant
`home_phone` has constant value "(123)555-0102"	Constant
`fax_number` has constant value "(123)555-0103"	Constant
`state_province` has constant value "WA"	Constant
`zip_postal_code` has constant value "99999"	Constant
`country_region` has constant value "USA"	Constant
`attachments` has constant value ""	Constant
`__table_name__` has constant value "employees"	Constant
`mobile_phone` has 9 (100.0%) missing values	Missing
`notes` has 3 (33.3%) missing values	Missing
`id` has unique values	Unique
`last_name` has unique values	Unique
`first_name` has unique values	Unique
`email_address` has unique values	Unique
`address` has unique values	Unique
`mobile_phone` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction
Analysis started 2025-10-30 16:47:07.629091
Analysis finished 2025-10-30 16:47:07.815765
Duration 0.19 seconds
Software version ydata-profiling vv4.17.0
Download configuration config.json

id
Real number (ℝ)

Unique

Distinct	9
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5

Minimum	1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	209.0 B

Quantile statistics
Minimum 1
5-th percentile 1.4
Q1 3
median 5
Q3 7
95-th percentile 8.6
Maximum 9
Range 8
Interquartile range (IQR) 4

Descriptive statistics
Standard deviation 2.738612788
Coefficient of variation (CV) 0.5477225575
Kurtosis -1.2
Mean 5
Median Absolute Deviation (MAD) 2
Skewness 0
Sum 45
Variance 7.5
Monotonicity Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
8	1	11.1%
5	1	11.1%
7	1	11.1%
1	1	11.1%
6	1	11.1%
3	1	11.1%
4	1	11.1%
2	1	11.1%
9	1	11.1%

Value	Count	Frequency (%)
1	1	11.1%
2	1	11.1%
3	1	11.1%
4	1	11.1%
5	1	11.1%

Value	Count	Frequency (%)
9	1	11.1%
8	1	11.1%
7	1	11.1%
6	1	11.1%
5	1	11.1%

company
Text

Constant

Distinct	1
Distinct (%)	11.1%
Missing	0
Missing (%)	0.0%
Memory size	794.0 B

Length
Max length 17
Median length 17
Mean length 17
Min length 17

Characters and Unicode
Total characters 153
Distinct characters 14
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row Northwind Traders
2nd row Northwind Traders
3rd row Northwind Traders
4th row Northwind Traders
5th row Northwind Traders

Value	Count	Frequency (%)
northwind	9	50.0%
traders	9	50.0%

Most occurring characters

Value	Count	Frequency (%)
r	27	17.6%
d	18	11.8%
o	9	5.9%
t	9	5.9%
h	9	5.9%
N	9	5.9%
w	9	5.9%
i	9	5.9%
n	9	5.9%
	9	5.9%
Other values (4)	36	23.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	153	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	27	17.6%
d	18	11.8%
o	9	5.9%
t	9	5.9%
h	9	5.9%
N	9	5.9%
w	9	5.9%
i	9	5.9%
n	9	5.9%
	9	5.9%
Other values (4)	36	23.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	153	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	27	17.6%
d	18	11.8%
o	9	5.9%
t	9	5.9%
h	9	5.9%
N	9	5.9%
w	9	5.9%
i	9	5.9%
n	9	5.9%
	9	5.9%
Other values (4)	36	23.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	153	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	27	17.6%
d	18	11.8%
o	9	5.9%
t	9	5.9%
h	9	5.9%
N	9	5.9%
w	9	5.9%
i	9	5.9%
n	9	5.9%
	9	5.9%
Other values (4)	36	23.5%

last_name
Text

Unique

Distinct	9
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	710.0 B

Length
Max length 14
Median length 8
Mean length 7.666666667
Min length 4

Characters and Unicode
Total characters 69
Distinct characters 27
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 9 ?
Unique (%) 100.0%

Sample
1st row Giussani
2nd row Thorpe
3rd row Zare
4th row Freehafer
5th row Neipper

Value	Count	Frequency (%)
giussani	1	11.1%
thorpe	1	11.1%
zare	1	11.1%
freehafer	1	11.1%
neipper	1	11.1%
kotas	1	11.1%
sergienko	1	11.1%
cencini	1	11.1%
hellung-larsen	1	11.1%

Most occurring characters

Value	Count	Frequency (%)
e	12	17.4%
r	7	10.1%
n	6	8.7%
i	6	8.7%
a	5	7.2%
s	4	5.8%
p	3	4.3%
o	3	4.3%
h	2	2.9%
g	2	2.9%
Other values (17)	19	27.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	69	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	12	17.4%
r	7	10.1%
n	6	8.7%
i	6	8.7%
a	5	7.2%
s	4	5.8%
p	3	4.3%
o	3	4.3%
h	2	2.9%
g	2	2.9%
Other values (17)	19	27.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	69	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	12	17.4%
r	7	10.1%
n	6	8.7%
i	6	8.7%
a	5	7.2%
s	4	5.8%
p	3	4.3%
o	3	4.3%
h	2	2.9%
g	2	2.9%
Other values (17)	19	27.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	69	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	12	17.4%
r	7	10.1%
n	6	8.7%
i	6	8.7%
a	5	7.2%
s	4	5.8%
p	3	4.3%
o	3	4.3%
h	2	2.9%
g	2	2.9%
Other values (17)	19	27.5%

first_name
Text

Unique

Distinct	9
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	689.0 B

Length
Max length 7
Median length 6
Mean length 5.333333333
Min length 3

Characters and Unicode
Total characters 48
Distinct characters 23
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 9 ?
Unique (%) 100.0%

Sample
1st row Laura
2nd row Steven
3rd row Robert
4th row Nancy
5th row Michael

Value	Count	Frequency (%)
laura	1	11.1%
steven	1	11.1%
robert	1	11.1%
nancy	1	11.1%
michael	1	11.1%
jan	1	11.1%
mariya	1	11.1%
andrew	1	11.1%
anne	1	11.1%

Most occurring characters

Value	Count	Frequency (%)
a	7	14.6%
e	6	12.5%
n	6	12.5%
r	4	8.3%
t	2	4.2%
y	2	4.2%
c	2	4.2%
i	2	4.2%
A	2	4.2%
M	2	4.2%
Other values (13)	13	27.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	48	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	7	14.6%
e	6	12.5%
n	6	12.5%
r	4	8.3%
t	2	4.2%
y	2	4.2%
c	2	4.2%
i	2	4.2%
A	2	4.2%
M	2	4.2%
Other values (13)	13	27.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	48	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	7	14.6%
e	6	12.5%
n	6	12.5%
r	4	8.3%
t	2	4.2%
y	2	4.2%
c	2	4.2%
i	2	4.2%
A	2	4.2%
M	2	4.2%
Other values (13)	13	27.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	48	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	7	14.6%
e	6	12.5%
n	6	12.5%
r	4	8.3%
t	2	4.2%
y	2	4.2%
c	2	4.2%
i	2	4.2%
A	2	4.2%
M	2	4.2%
Other values (13)	13	27.1%

email_address
Text

Unique

Distinct	9
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	878.0 B

Length
Max length 28
Median length 27
Mean length 26.33333333
Min length 24

Characters and Unicode
Total characters 237
Distinct characters 21
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 9 ?
Unique (%) 100.0%

Sample
1st row laura@northwindtraders.com
2nd row steven@northwindtraders.com
3rd row robert@northwindtraders.com
4th row nancy@northwindtraders.com
5th row michael@northwindtraders.com

Value	Count	Frequency (%)
laura@northwindtraders.com	1	11.1%
steven@northwindtraders.com	1	11.1%
robert@northwindtraders.com	1	11.1%
nancy@northwindtraders.com	1	11.1%
michael@northwindtraders.com	1	11.1%
jan@northwindtraders.com	1	11.1%
mariya@northwindtraders.com	1	11.1%
andrew@northwindtraders.com	1	11.1%
anne@northwindtraders.com	1	11.1%

Most occurring characters

Value	Count	Frequency (%)
r	32	13.5%
n	25	10.5%
t	20	8.4%
d	19	8.0%
o	19	8.0%
a	18	7.6%
e	15	6.3%
c	11	4.6%
i	11	4.6%
m	11	4.6%
Other values (11)	56	23.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	237	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	32	13.5%
n	25	10.5%
t	20	8.4%
d	19	8.0%
o	19	8.0%
a	18	7.6%
e	15	6.3%
c	11	4.6%
i	11	4.6%
m	11	4.6%
Other values (11)	56	23.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	237	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	32	13.5%
n	25	10.5%
t	20	8.4%
d	19	8.0%
o	19	8.0%
a	18	7.6%
e	15	6.3%
c	11	4.6%
i	11	4.6%
m	11	4.6%
Other values (11)	56	23.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	237	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	32	13.5%
n	25	10.5%
t	20	8.4%
d	19	8.0%
o	19	8.0%
a	18	7.6%
e	15	6.3%
c	11	4.6%
i	11	4.6%
m	11	4.6%
Other values (11)	56	23.6%

job_title
Text

Distinct	4
Distinct (%)	44.4%
Missing	0
Missing (%)	0.0%
Memory size	812.0 B

Length
Max length 21
Median length 20
Mean length 19
Min length 13

Characters and Unicode
Total characters 171
Distinct characters 22
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 3 ?
Unique (%) 33.3%

Sample
1st row Sales Coordinator
2nd row Sales Manager
3rd row Sales Representative
4th row Sales Representative
5th row Sales Representative

Value	Count	Frequency (%)
sales	9	47.4%
representative	6	31.6%
coordinator	1	5.3%
manager	1	5.3%
vice	1	5.3%
president	1	5.3%

Most occurring characters

Value	Count	Frequency (%)
e	37	21.6%
a	18	10.5%
s	16	9.4%
t	14	8.2%
r	10	5.8%
	10	5.8%
l	9	5.3%
S	9	5.3%
i	9	5.3%
n	9	5.3%
Other values (12)	30	17.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	171	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	37	21.6%
a	18	10.5%
s	16	9.4%
t	14	8.2%
r	10	5.8%
	10	5.8%
l	9	5.3%
S	9	5.3%
i	9	5.3%
n	9	5.3%
Other values (12)	30	17.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	171	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	37	21.6%
a	18	10.5%
s	16	9.4%
t	14	8.2%
r	10	5.8%
	10	5.8%
l	9	5.3%
S	9	5.3%
i	9	5.3%
n	9	5.3%
Other values (12)	30	17.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	171	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	37	21.6%
a	18	10.5%
s	16	9.4%
t	14	8.2%
r	10	5.8%
	10	5.8%
l	9	5.3%
S	9	5.3%
i	9	5.3%
n	9	5.3%
Other values (12)	30	17.5%

business_phone
Text

Constant

Distinct	1
Distinct (%)	11.1%
Missing	0
Missing (%)	0.0%
Memory size	758.0 B

Length
Max length 13
Median length 13
Mean length 13
Min length 13

Characters and Unicode
Total characters 117
Distinct characters 8
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row (123)555-0100
2nd row (123)555-0100
3rd row (123)555-0100
4th row (123)555-0100
5th row (123)555-0100

Value	Count	Frequency (%)
123)555-0100	9	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	27	23.1%
5	27	23.1%
1	18	15.4%
(	9	7.7%
3	9	7.7%
2	9	7.7%
)	9	7.7%
-	9	7.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	117	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	27	23.1%
5	27	23.1%
1	18	15.4%
(	9	7.7%
3	9	7.7%
2	9	7.7%
)	9	7.7%
-	9	7.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	117	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	27	23.1%
5	27	23.1%
1	18	15.4%
(	9	7.7%
3	9	7.7%
2	9	7.7%
)	9	7.7%
-	9	7.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	117	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	27	23.1%
5	27	23.1%
1	18	15.4%
(	9	7.7%
3	9	7.7%
2	9	7.7%
)	9	7.7%
-	9	7.7%

home_phone
Text

Constant

Distinct	1
Distinct (%)	11.1%
Missing	0
Missing (%)	0.0%
Memory size	758.0 B

Length
Max length 13
Median length 13
Mean length 13
Min length 13

Characters and Unicode
Total characters 117
Distinct characters 8
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row (123)555-0102
2nd row (123)555-0102
3rd row (123)555-0102
4th row (123)555-0102
5th row (123)555-0102

Value	Count	Frequency (%)
123)555-0102	9	100.0%

Most occurring characters

Value	Count	Frequency (%)
5	27	23.1%
1	18	15.4%
0	18	15.4%
2	18	15.4%
3	9	7.7%
(	9	7.7%
)	9	7.7%
-	9	7.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	117	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
5	27	23.1%
1	18	15.4%
0	18	15.4%
2	18	15.4%
3	9	7.7%
(	9	7.7%
)	9	7.7%
-	9	7.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	117	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
5	27	23.1%
1	18	15.4%
0	18	15.4%
2	18	15.4%
3	9	7.7%
(	9	7.7%
)	9	7.7%
-	9	7.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	117	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
5	27	23.1%
1	18	15.4%
0	18	15.4%
2	18	15.4%
3	9	7.7%
(	9	7.7%
)	9	7.7%
-	9	7.7%

mobile_phone
Unsupported

Missing Rejected Unsupported

Missing	9
Missing (%)	100.0%
Memory size	200.0 B

fax_number
Text

Constant

Distinct	1
Distinct (%)	11.1%
Missing	0
Missing (%)	0.0%
Memory size	758.0 B

Length
Max length 13
Median length 13
Mean length 13
Min length 13

Characters and Unicode
Total characters 117
Distinct characters 8
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row (123)555-0103
2nd row (123)555-0103
3rd row (123)555-0103
4th row (123)555-0103
5th row (123)555-0103

Value	Count	Frequency (%)
123)555-0103	9	100.0%

Most occurring characters

Value	Count	Frequency (%)
5	27	23.1%
1	18	15.4%
0	18	15.4%
3	18	15.4%
2	9	7.7%
(	9	7.7%
)	9	7.7%
-	9	7.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	117	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
5	27	23.1%
1	18	15.4%
0	18	15.4%
3	18	15.4%
2	9	7.7%
(	9	7.7%
)	9	7.7%
-	9	7.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	117	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
5	27	23.1%
1	18	15.4%
0	18	15.4%
3	18	15.4%
2	9	7.7%
(	9	7.7%
)	9	7.7%
-	9	7.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	117	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
5	27	23.1%
1	18	15.4%
0	18	15.4%
3	18	15.4%
2	9	7.7%
(	9	7.7%
)	9	7.7%
-	9	7.7%

address
Text

Unique

Distinct	9
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	767.0 B

Length
Max length 14
Median length 14
Mean length 14
Min length 14

Characters and Unicode
Total characters 126
Distinct characters 20
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 9 ?
Unique (%) 100.0%

Sample
1st row 123 8th Avenue
2nd row 123 5th Avenue
3rd row 123 7th Avenue
4th row 123 1st Avenue
5th row 123 6th Avenue

Value	Count	Frequency (%)
123	9	33.3%
avenue	9	33.3%
8th	1	3.7%
5th	1	3.7%
7th	1	3.7%
1st	1	3.7%
6th	1	3.7%
3rd	1	3.7%
4th	1	3.7%
2nd	1	3.7%

Most occurring characters

Value	Count	Frequency (%)
	18	14.3%
e	18	14.3%
2	10	7.9%
1	10	7.9%
3	10	7.9%
n	10	7.9%
A	9	7.1%
v	9	7.1%
u	9	7.1%
t	7	5.6%
Other values (10)	16	12.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	126	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	18	14.3%
e	18	14.3%
2	10	7.9%
1	10	7.9%
3	10	7.9%
n	10	7.9%
A	9	7.1%
v	9	7.1%
u	9	7.1%
t	7	5.6%
Other values (10)	16	12.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	126	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	18	14.3%
e	18	14.3%
2	10	7.9%
1	10	7.9%
3	10	7.9%
n	10	7.9%
A	9	7.1%
v	9	7.1%
u	9	7.1%
t	7	5.6%
Other values (10)	16	12.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	126	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	18	14.3%
e	18	14.3%
2	10	7.9%
1	10	7.9%
3	10	7.9%
n	10	7.9%
A	9	7.1%
v	9	7.1%
u	9	7.1%
t	7	5.6%
Other values (10)	16	12.7%

city
Text

Distinct	4
Distinct (%)	44.4%
Missing	0
Missing (%)	0.0%
Memory size	706.0 B

Length
Max length 8
Median length 7
Mean length 7.222222222
Min length 7

Characters and Unicode
Total characters 65
Distinct characters 17
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 2 ?
Unique (%) 22.2%

Sample
1st row Redmond
2nd row Seattle
3rd row Seattle
4th row Seattle
5th row Redmond

Value	Count	Frequency (%)
seattle	4	44.4%
redmond	3	33.3%
kirkland	1	11.1%
bellevue	1	11.1%

Most occurring characters

Value	Count	Frequency (%)
e	14	21.5%
t	8	12.3%
l	7	10.8%
d	7	10.8%
a	5	7.7%
S	4	6.2%
n	4	6.2%
m	3	4.6%
R	3	4.6%
o	3	4.6%
Other values (7)	7	10.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	65	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	14	21.5%
t	8	12.3%
l	7	10.8%
d	7	10.8%
a	5	7.7%
S	4	6.2%
n	4	6.2%
m	3	4.6%
R	3	4.6%
o	3	4.6%
Other values (7)	7	10.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	65	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	14	21.5%
t	8	12.3%
l	7	10.8%
d	7	10.8%
a	5	7.7%
S	4	6.2%
n	4	6.2%
m	3	4.6%
R	3	4.6%
o	3	4.6%
Other values (7)	7	10.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	65	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	14	21.5%
t	8	12.3%
l	7	10.8%
d	7	10.8%
a	5	7.7%
S	4	6.2%
n	4	6.2%
m	3	4.6%
R	3	4.6%
o	3	4.6%
Other values (7)	7	10.8%

state_province
Text

Constant

Distinct	1
Distinct (%)	11.1%
Missing	0
Missing (%)	0.0%
Memory size	659.0 B

Length
Max length 2
Median length 2
Mean length 2
Min length 2

Characters and Unicode
Total characters 18
Distinct characters 2
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row WA
2nd row WA
3rd row WA
4th row WA
5th row WA

Value	Count	Frequency (%)
wa	9	100.0%

Most occurring characters

Value	Count	Frequency (%)
W	9	50.0%
A	9	50.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	18	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
W	9	50.0%
A	9	50.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	18	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
W	9	50.0%
A	9	50.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	18	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
W	9	50.0%
A	9	50.0%

zip_postal_code
Text

Constant

Distinct	1
Distinct (%)	11.1%
Missing	0
Missing (%)	0.0%
Memory size	686.0 B

Length
Max length 5
Median length 5
Mean length 5
Min length 5

Characters and Unicode
Total characters 45
Distinct characters 1
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row 99999
2nd row 99999
3rd row 99999
4th row 99999
5th row 99999

Value	Count	Frequency (%)
99999	9	100.0%

Most occurring characters

Value	Count	Frequency (%)
9	45	100.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	45	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
9	45	100.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	45	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
9	45	100.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	45	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
9	45	100.0%

country_region
Text

Constant

Distinct	1
Distinct (%)	11.1%
Missing	0
Missing (%)	0.0%
Memory size	668.0 B

Length
Max length 3
Median length 3
Mean length 3
Min length 3

Characters and Unicode
Total characters 27
Distinct characters 3
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row USA
2nd row USA
3rd row USA
4th row USA
5th row USA

Value	Count	Frequency (%)
usa	9	100.0%

Most occurring characters

Value	Count	Frequency (%)
U	9	33.3%
S	9	33.3%
A	9	33.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	27	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
U	9	33.3%
S	9	33.3%
A	9	33.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	27	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
U	9	33.3%
S	9	33.3%
A	9	33.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	27	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
U	9	33.3%
S	9	33.3%
A	9	33.3%

web_page
Text

Distinct	2
Distinct (%)	22.2%
Missing	0
Missing (%)	0.0%
Memory size	1.1 KiB

Length
Max length 57
Median length 57
Mean length 53.88888889
Min length 29

Characters and Unicode
Total characters 485
Distinct characters 18
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 1 ?
Unique (%) 11.1%

Sample
1st row http://northwindtraders.com#http://northwindtraders.com/#
2nd row http://northwindtraders.com#http://northwindtraders.com/#
3rd row http://northwindtraders.com#http://northwindtraders.com/#
4th row #http://northwindtraders.com#
5th row http://northwindtraders.com#http://northwindtraders.com/#

Value	Count	Frequency (%)
http://northwindtraders.com#http://northwindtraders.com	8	88.9%
http://northwindtraders.com	1	11.1%

Most occurring characters

Value	Count	Frequency (%)
t	68	14.0%
r	51	10.5%
/	42	8.7%
h	34	7.0%
o	34	7.0%
n	34	7.0%
d	34	7.0%
#	18	3.7%
p	17	3.5%
:	17	3.5%
Other values (8)	136	28.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	485	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	68	14.0%
r	51	10.5%
/	42	8.7%
h	34	7.0%
o	34	7.0%
n	34	7.0%
d	34	7.0%
#	18	3.7%
p	17	3.5%
:	17	3.5%
Other values (8)	136	28.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	485	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	68	14.0%
r	51	10.5%
/	42	8.7%
h	34	7.0%
o	34	7.0%
n	34	7.0%
d	34	7.0%
#	18	3.7%
p	17	3.5%
:	17	3.5%
Other values (8)	136	28.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	485	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	68	14.0%
r	51	10.5%
/	42	8.7%
h	34	7.0%
o	34	7.0%
n	34	7.0%
d	34	7.0%
#	18	3.7%
p	17	3.5%
:	17	3.5%
Other values (8)	136	28.0%

notes
Text

Missing

Distinct	6
Distinct (%)	100.0%
Missing	3
Missing (%)	33.3%
Memory size	981.0 B

Length
Max length 119
Median length 73
Mean length 69.16666667
Min length 24

Characters and Unicode
Total characters 415
Distinct characters 30
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 6 ?
Unique (%) 100.0%

Sample
1st row Reads and writes French.
2nd row Joined the company as a sales representative and was promoted to sales manager. Fluent in French.
3rd row Fluent in Japanese and can read and write French, Portuguese, and Spanish.
4th row Was hired as a sales associate and was promoted to sales representative.
5th row Joined the company as a sales representative, was promoted to sales manager and was then named vice president of sales.

Value	Count	Frequency (%)
and	8	11.6%
sales	7	10.1%
was	5	7.2%
french	4	5.8%
a	3	4.3%
as	3	4.3%
representative	3	4.3%
to	3	4.3%
promoted	3	4.3%
in	3	4.3%
Other values (21)	27	39.1%

Most occurring characters

Value	Count	Frequency (%)
	64	15.4%
e	51	12.3%
a	45	10.8%
n	34	8.2%
s	33	8.0%
t	23	5.5%
r	22	5.3%
d	18	4.3%
o	16	3.9%
i	15	3.6%
Other values (20)	94	22.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	415	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	64	15.4%
e	51	12.3%
a	45	10.8%
n	34	8.2%
s	33	8.0%
t	23	5.5%
r	22	5.3%
d	18	4.3%
o	16	3.9%
i	15	3.6%
Other values (20)	94	22.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	415	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	64	15.4%
e	51	12.3%
a	45	10.8%
n	34	8.2%
s	33	8.0%
t	23	5.5%
r	22	5.3%
d	18	4.3%
o	16	3.9%
i	15	3.6%
Other values (20)	94	22.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	415	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	64	15.4%
e	51	12.3%
a	45	10.8%
n	34	8.2%
s	33	8.0%
t	23	5.5%
r	22	5.3%
d	18	4.3%
o	16	3.9%
i	15	3.6%
Other values (20)	94	22.7%

attachments
Text

Constant

Distinct	1
Distinct (%)	11.1%
Missing	0
Missing (%)	0.0%
Memory size	641.0 B

Length
Max length 0
Median length 0
Mean length 0
Min length 0

Characters and Unicode
Total characters 0
Distinct characters 0
Distinct categories 0 ?
Distinct scripts 0 ?
Distinct blocks 0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row
2nd row
3rd row
4th row
5th row

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

__table_name__
Text

Constant

Distinct	1
Distinct (%)	11.1%
Missing	0
Missing (%)	0.0%
Memory size	722.0 B

Length
Max length 9
Median length 9
Mean length 9
Min length 9

Characters and Unicode
Total characters 81
Distinct characters 7
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row employees
2nd row employees
3rd row employees
4th row employees
5th row employees

Value	Count	Frequency (%)
employees	9	100.0%

Most occurring characters

Value	Count	Frequency (%)
e	27	33.3%
m	9	11.1%
p	9	11.1%
l	9	11.1%
o	9	11.1%
y	9	11.1%
s	9	11.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	81	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	27	33.3%
m	9	11.1%
p	9	11.1%
l	9	11.1%
o	9	11.1%
y	9	11.1%
s	9	11.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	81	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	27	33.3%
m	9	11.1%
p	9	11.1%
l	9	11.1%
o	9	11.1%
y	9	11.1%
s	9	11.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	81	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	27	33.3%
m	9	11.1%
p	9	11.1%
l	9	11.1%
o	9	11.1%
y	9	11.1%
s	9	11.1%

Table: inventory_transaction_types

Profile: inventory_transaction_types

Overview

Brought to you by YData

Dataset statistics
Number of variables 3
Number of observations 4
Missing cells 0
Missing cells (%) 0.0%
Total size in memory 753.0 B
Average record size in memory 188.2 B

Variable types
Numeric 1
Text 2

Alerts

`__table_name__` has constant value "inventory_transaction_types"	Constant
`id` has unique values	Unique
`type_name` has unique values	Unique

Reproduction
Analysis started 2025-10-30 16:47:12.185719
Analysis finished 2025-10-30 16:47:12.221050
Duration 0.04 seconds
Software version ydata-profiling vv4.17.0
Download configuration config.json

id
Real number (ℝ)

Unique

Distinct	4
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.5

Minimum	1
Maximum	4
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	164.0 B

Quantile statistics
Minimum 1
5-th percentile 1.15
Q1 1.75
median 2.5
Q3 3.25
95-th percentile 3.85
Maximum 4
Range 3
Interquartile range (IQR) 1.5

Descriptive statistics
Standard deviation 1.290994449
Coefficient of variation (CV) 0.5163977795
Kurtosis -1.2
Mean 2.5
Median Absolute Deviation (MAD) 1
Skewness 0
Sum 10
Variance 1.666666667
Monotonicity Strictly increasing

Histogram with fixed size bins (bins=4)

Value	Count	Frequency (%)
1	1	25.0%
2	1	25.0%
3	1	25.0%
4	1	25.0%

Value	Count	Frequency (%)
1	1	25.0%
2	1	25.0%
3	1	25.0%
4	1	25.0%

Value	Count	Frequency (%)
4	1	25.0%
3	1	25.0%
2	1	25.0%
1	1	25.0%

type_name
Text

Unique

Distinct	4
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	381.0 B

Length
Max length 9
Median length 6
Mean length 6.25
Min length 4

Characters and Unicode
Total characters 25
Distinct characters 18
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 4 ?
Unique (%) 100.0%

Sample
1st row Purchased
2nd row Sold
3rd row On Hold
4th row Waste

Value	Count	Frequency (%)
purchased	1	20.0%
sold	1	20.0%
on	1	20.0%
hold	1	20.0%
waste	1	20.0%

Most occurring characters

Value	Count	Frequency (%)
d	3	12.0%
a	2	8.0%
l	2	8.0%
o	2	8.0%
s	2	8.0%
e	2	8.0%
u	1	4.0%
P	1	4.0%
h	1	4.0%
c	1	4.0%
Other values (8)	8	32.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	25	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
d	3	12.0%
a	2	8.0%
l	2	8.0%
o	2	8.0%
s	2	8.0%
e	2	8.0%
u	1	4.0%
P	1	4.0%
h	1	4.0%
c	1	4.0%
Other values (8)	8	32.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	25	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
d	3	12.0%
a	2	8.0%
l	2	8.0%
o	2	8.0%
s	2	8.0%
e	2	8.0%
u	1	4.0%
P	1	4.0%
h	1	4.0%
c	1	4.0%
Other values (8)	8	32.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	25	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
d	3	12.0%
a	2	8.0%
l	2	8.0%
o	2	8.0%
s	2	8.0%
e	2	8.0%
u	1	4.0%
P	1	4.0%
h	1	4.0%
c	1	4.0%
Other values (8)	8	32.0%

__table_name__
Text

Constant

Distinct	1
Distinct (%)	25.0%
Missing	0
Missing (%)	0.0%
Memory size	464.0 B

Length
Max length 27
Median length 27
Mean length 27
Min length 27

Characters and Unicode
Total characters 108
Distinct characters 13
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row inventory_transaction_types
2nd row inventory_transaction_types
3rd row inventory_transaction_types
4th row inventory_transaction_types

Value	Count	Frequency (%)
inventory_transaction_types	4	100.0%

Most occurring characters

Value	Count	Frequency (%)
n	16	14.8%
t	16	14.8%
i	8	7.4%
e	8	7.4%
o	8	7.4%
a	8	7.4%
r	8	7.4%
y	8	7.4%
_	8	7.4%
s	8	7.4%
Other values (3)	12	11.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	108	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	16	14.8%
t	16	14.8%
i	8	7.4%
e	8	7.4%
o	8	7.4%
a	8	7.4%
r	8	7.4%
y	8	7.4%
_	8	7.4%
s	8	7.4%
Other values (3)	12	11.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	108	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	16	14.8%
t	16	14.8%
i	8	7.4%
e	8	7.4%
o	8	7.4%
a	8	7.4%
r	8	7.4%
y	8	7.4%
_	8	7.4%
s	8	7.4%
Other values (3)	12	11.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	108	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	16	14.8%
t	16	14.8%
i	8	7.4%
e	8	7.4%
o	8	7.4%
a	8	7.4%
r	8	7.4%
y	8	7.4%
_	8	7.4%
s	8	7.4%
Other values (3)	12	11.1%

Table: inventory_transactions

Profile: inventory_transactions

Overview

Brought to you by YData

Dataset statistics
Number of variables 10
Number of observations 102
Missing cells 292
Missing cells (%) 28.6%
Total size in memory 18.3 KiB
Average record size in memory 183.7 B

Variable types
Numeric 4
DateTime 2
Unsupported 2
Text 2

Alerts

`__table_name__` has constant value "inventory_transactions"	Constant
`purchase_order_id` has 102 (100.0%) missing values	Missing
`customer_order_id` has 102 (100.0%) missing values	Missing
`comments` has 88 (86.3%) missing values	Missing
`id` has unique values	Unique
`transaction_created_date` has unique values	Unique
`purchase_order_id` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`customer_order_id` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction
Analysis started 2025-10-30 16:47:13.500625
Analysis finished 2025-10-30 16:47:13.574116
Duration 0.07 seconds
Software version ydata-profiling vv4.17.0
Download configuration config.json

id
Real number (ℝ)

Unique

Distinct	102
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	85.5

Minimum	35
Maximum	136
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics
Minimum 35
5-th percentile 40.05
Q1 60.25
median 85.5
Q3 110.75
95-th percentile 130.95
Maximum 136
Range 101
Interquartile range (IQR) 50.5

Descriptive statistics
Standard deviation 29.58884925
Coefficient of variation (CV) 0.3460684123
Kurtosis -1.2
Mean 85.5
Median Absolute Deviation (MAD) 25.5
Skewness 0
Sum 8721
Variance 875.5
Monotonicity Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
111	1	1.0%
45	1	1.0%
47	1	1.0%
52	1	1.0%
105	1	1.0%
109	1	1.0%
80	1	1.0%
36	1	1.0%
41	1	1.0%
42	1	1.0%
Other values (92)	92	90.2%

Value	Count	Frequency (%)
35	1	1.0%
36	1	1.0%
37	1	1.0%
38	1	1.0%
39	1	1.0%

Value	Count	Frequency (%)
136	1	1.0%
135	1	1.0%
134	1	1.0%
133	1	1.0%
132	1	1.0%

transaction_type
Real number (ℝ)

Distinct	3
Distinct (%)	2.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.676470588

Minimum	1
Maximum	3
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics
Minimum 1
5-th percentile 1
Q1 1
median 2
Q3 2
95-th percentile 3
Maximum 3
Range 2
Interquartile range (IQR) 1

Descriptive statistics
Standard deviation 0.6473367328
Coefficient of variation (CV) 0.3861306827
Kurtosis -0.6842029788
Mean 1.676470588
Median Absolute Deviation (MAD) 1
Skewness 0.4293638873
Sum 171
Variance 0.4190448457
Monotonicity Increasing

Histogram with fixed size bins (bins=3)

Value	Count	Frequency (%)
2	49	48.0%
1	43	42.2%
3	10	9.8%

Value	Count	Frequency (%)
1	43	42.2%
2	49	48.0%
3	10	9.8%

Value	Count	Frequency (%)
3	10	9.8%
2	49	48.0%
1	43	42.2%

transaction_created_date
Date

Unique

Distinct	102
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	944.0 B

Minimum	2006-03-22 16:02:28
Maximum	2006-04-25 17:04:05
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

transaction_modified_date
Date

Distinct	88
Distinct (%)	86.3%
Missing	0
Missing (%)	0.0%
Memory size	944.0 B

Minimum	2006-03-22 16:02:28
Maximum	2006-04-25 17:04:57
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

product_id
Real number (ℝ)

Distinct	28
Distinct (%)	27.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.80392157

Minimum	1
Maximum	81
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics
Minimum 1
5-th percentile 4
Q1 19
median 40.5
Q3 51.75
95-th percentile 80
Maximum 81
Range 80
Interquartile range (IQR) 32.75

Descriptive statistics
Standard deviation 24.61788741
Coefficient of variation (CV) 0.6511993039
Kurtosis -0.9794910262
Mean 37.80392157
Median Absolute Deviation (MAD) 21.5
Skewness 0.2176139641
Sum 3856
Variance 606.0403805
Monotonicity Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
34	10	9.8%
19	8	7.8%
43	8	7.8%
41	7	6.9%
48	7	6.9%
8	6	5.9%
80	5	4.9%
81	5	4.9%
40	4	3.9%
72	4	3.9%
Other values (18)	38	37.3%

Value	Count	Frequency (%)
1	3	2.9%
3	2	2.0%
4	3	2.9%
5	2	2.0%
6	3	2.9%

Value	Count	Frequency (%)
81	5	4.9%
80	5	4.9%
77	1	1.0%
74	2	2.0%
72	4	3.9%

quantity
Real number (ℝ)

Distinct	24
Distinct (%)	23.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.85294118

Minimum	1
Maximum	300
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics
Minimum 1
5-th percentile 10
Q1 20
median 40
Q3 89.25
95-th percentile 247.5
Maximum 300
Range 299
Interquartile range (IQR) 69.25

Descriptive statistics
Standard deviation 71.72104888
Coefficient of variation (CV) 1.105902795
Kurtosis 4.094259858
Mean 64.85294118
Median Absolute Deviation (MAD) 20
Skewness 2.118255623
Sum 6615
Variance 5143.908853
Monotonicity Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
40	19	18.6%
10	11	10.8%
100	11	10.8%
20	9	8.8%
30	8	7.8%
50	8	7.8%
25	8	7.8%
300	5	4.9%
200	4	3.9%
60	2	2.0%
Other values (14)	17	16.7%

Value	Count	Frequency (%)
1	1	1.0%
3	1	1.0%
5	1	1.0%
10	11	10.8%
12	1	1.0%

Value	Count	Frequency (%)
300	5	4.9%
250	1	1.0%
200	4	3.9%
125	1	1.0%
120	2	2.0%

purchase_order_id
Unsupported

Missing Rejected Unsupported

Missing	102
Missing (%)	100.0%
Memory size	1.0 KiB

customer_order_id
Unsupported

Missing Rejected Unsupported

Missing	102
Missing (%)	100.0%
Memory size	1.0 KiB

comments
Text

Missing

Distinct	12
Distinct (%)	85.7%
Missing	88
Missing (%)	86.3%
Memory size	4.1 KiB

Length
Max length 36
Median length 36
Mean length 36
Min length 36

Characters and Unicode
Total characters 504
Distinct characters 28
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 10 ?
Unique (%) 71.4%

Sample
1st row Fill Back Ordered product, Order #42
2nd row Fill Back Ordered product, Order #48
3rd row Fill Back Ordered product, Order #48
4th row Fill Back Ordered product, Order #33
5th row Fill Back Ordered product, Order #46

Value	Count	Frequency (%)
fill	14	16.7%
back	14	16.7%
ordered	14	16.7%
product	14	16.7%
order	14	16.7%
48	2	2.4%
46	2	2.4%
42	1	1.2%
33	1	1.2%
45	1	1.2%
Other values (7)	7	8.3%

Most occurring characters

Value	Count	Frequency (%)
	70	13.9%
r	70	13.9%
d	56	11.1%
e	42	8.3%
O	28	5.6%
c	28	5.6%
l	28	5.6%
i	14	2.8%
F	14	2.8%
k	14	2.8%
Other values (18)	140	27.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	504	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	70	13.9%
r	70	13.9%
d	56	11.1%
e	42	8.3%
O	28	5.6%
c	28	5.6%
l	28	5.6%
i	14	2.8%
F	14	2.8%
k	14	2.8%
Other values (18)	140	27.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	504	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	70	13.9%
r	70	13.9%
d	56	11.1%
e	42	8.3%
O	28	5.6%
c	28	5.6%
l	28	5.6%
i	14	2.8%
F	14	2.8%
k	14	2.8%
Other values (18)	140	27.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	504	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	70	13.9%
r	70	13.9%
d	56	11.1%
e	42	8.3%
O	28	5.6%
c	28	5.6%
l	28	5.6%
i	14	2.8%
F	14	2.8%
k	14	2.8%
Other values (18)	140	27.8%

__table_name__
Text

Constant

Distinct	1
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	8.0 KiB

Length
Max length 22
Median length 22
Mean length 22
Min length 22

Characters and Unicode
Total characters 2244
Distinct characters 12
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row inventory_transactions
2nd row inventory_transactions
3rd row inventory_transactions
4th row inventory_transactions
5th row inventory_transactions

Value	Count	Frequency (%)
inventory_transactions	102	100.0%

Most occurring characters

Value	Count	Frequency (%)
n	408	18.2%
t	306	13.6%
o	204	9.1%
i	204	9.1%
s	204	9.1%
a	204	9.1%
r	204	9.1%
v	102	4.5%
e	102	4.5%
y	102	4.5%
Other values (2)	204	9.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2244	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	408	18.2%
t	306	13.6%
o	204	9.1%
i	204	9.1%
s	204	9.1%
a	204	9.1%
r	204	9.1%
v	102	4.5%
e	102	4.5%
y	102	4.5%
Other values (2)	204	9.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2244	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	408	18.2%
t	306	13.6%
o	204	9.1%
i	204	9.1%
s	204	9.1%
a	204	9.1%
r	204	9.1%
v	102	4.5%
e	102	4.5%
y	102	4.5%
Other values (2)	204	9.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2244	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	408	18.2%
t	306	13.6%
o	204	9.1%
i	204	9.1%
s	204	9.1%
a	204	9.1%
r	204	9.1%
v	102	4.5%
e	102	4.5%
y	102	4.5%
Other values (2)	204	9.1%

Table: invoices

Profile: invoices

Overview

Brought to you by YData

Dataset statistics
Number of variables 8
Number of observations 35
Missing cells 35
Missing cells (%) 12.5%
Total size in memory 4.3 KiB
Average record size in memory 126.7 B

Variable types
Numeric 5
DateTime 1
Unsupported 1
Text 1

Alerts

`tax` has constant value "0.0"	Constant
`shipping` has constant value "0.0"	Constant
`amount_due` has constant value "0.0"	Constant
`__table_name__` has constant value "invoices"	Constant
`due_date` has 35 (100.0%) missing values	Missing
`id` has unique values	Unique
`order_id` has unique values	Unique
`invoice_date` has unique values	Unique
`due_date` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`tax` has 35 (100.0%) zeros	Zeros
`shipping` has 35 (100.0%) zeros	Zeros
`amount_due` has 35 (100.0%) zeros	Zeros

Reproduction
Analysis started 2025-10-30 16:47:16.159970
Analysis finished 2025-10-30 16:47:16.214187
Duration 0.05 seconds
Software version ydata-profiling vv4.17.0
Download configuration config.json

id
Real number (ℝ)

Unique

Distinct	35
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22

Minimum	5
Maximum	39
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	443.0 B

Quantile statistics
Minimum 5
5-th percentile 6.7
Q1 13.5
median 22
Q3 30.5
95-th percentile 37.3
Maximum 39
Range 34
Interquartile range (IQR) 17

Descriptive statistics
Standard deviation 10.24695077
Coefficient of variation (CV) 0.4657704894
Kurtosis -1.2
Mean 22
Median Absolute Deviation (MAD) 9
Skewness 0
Sum 770
Variance 105
Monotonicity Not monotonic

Histogram with fixed size bins (bins=35)

Value	Count	Frequency (%)
7	1	2.9%
6	1	2.9%
8	1	2.9%
5	1	2.9%
9	1	2.9%
17	1	2.9%
10	1	2.9%
18	1	2.9%
11	1	2.9%
19	1	2.9%
Other values (25)	25	71.4%

Value	Count	Frequency (%)
5	1	2.9%
6	1	2.9%
7	1	2.9%
8	1	2.9%
9	1	2.9%

Value	Count	Frequency (%)
39	1	2.9%
38	1	2.9%
37	1	2.9%
36	1	2.9%
35	1	2.9%

order_id
Real number (ℝ)

Unique

Distinct	35
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	53.91428571

Minimum	30
Maximum	79
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	443.0 B

Quantile statistics
Minimum 30
5-th percentile 31.7
Q1 38.5
median 51
Q3 70.5
95-th percentile 77.3
Maximum 79
Range 49
Interquartile range (IQR) 32

Descriptive statistics
Standard deviation 16.53582818
Coefficient of variation (CV) 0.306705875
Kurtosis -1.511474153
Mean 53.91428571
Median Absolute Deviation (MAD) 16
Skewness 0.1025743054
Sum 1887
Variance 273.4336134
Monotonicity Not monotonic

Histogram with fixed size bins (bins=35)

Value	Count	Frequency (%)
40	1	2.9%
32	1	2.9%
39	1	2.9%
31	1	2.9%
38	1	2.9%
55	1	2.9%
37	1	2.9%
51	1	2.9%
36	1	2.9%
50	1	2.9%
Other values (25)	25	71.4%

Value	Count	Frequency (%)
30	1	2.9%
31	1	2.9%
32	1	2.9%
33	1	2.9%
34	1	2.9%

Value	Count	Frequency (%)
79	1	2.9%
78	1	2.9%
77	1	2.9%
76	1	2.9%
75	1	2.9%

invoice_date
Date

Unique

Distinct	35
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	408.0 B

Minimum	2006-03-22 16:08:59
Maximum	2006-04-04 11:43:08
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=35)

due_date
Unsupported

Missing Rejected Unsupported

Missing	35
Missing (%)	100.0%
Memory size	408.0 B

tax
Real number (ℝ)

Constant Zeros

Distinct	1
Distinct (%)	2.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0

Minimum	0
Maximum	0
Zeros	35
Zeros (%)	100.0%
Negative	0
Negative (%)	0.0%
Memory size	408.0 B

Quantile statistics
Minimum 0
5-th percentile 0
Q1 0
median 0
Q3 0
95-th percentile 0
Maximum 0
Range 0
Interquartile range (IQR) 0

Descriptive statistics
Standard deviation 0
Coefficient of variation (CV) nan
Kurtosis 0
Mean 0
Median Absolute Deviation (MAD) 0
Skewness 0
Sum 0
Variance 0
Monotonicity Increasing

Histogram with fixed size bins (bins=1)

Value	Count	Frequency (%)
0	35	100.0%

Value	Count	Frequency (%)
0	35	100.0%

Value	Count	Frequency (%)
0	35	100.0%

shipping
Real number (ℝ)

Constant Zeros

Distinct	1
Distinct (%)	2.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0

Minimum	0
Maximum	0
Zeros	35
Zeros (%)	100.0%
Negative	0
Negative (%)	0.0%
Memory size	408.0 B

Quantile statistics
Minimum 0
5-th percentile 0
Q1 0
median 0
Q3 0
95-th percentile 0
Maximum 0
Range 0
Interquartile range (IQR) 0

Descriptive statistics
Standard deviation 0
Coefficient of variation (CV) nan
Kurtosis 0
Mean 0
Median Absolute Deviation (MAD) 0
Skewness 0
Sum 0
Variance 0
Monotonicity Increasing

Histogram with fixed size bins (bins=1)

Value	Count	Frequency (%)
0	35	100.0%

Value	Count	Frequency (%)
0	35	100.0%

Value	Count	Frequency (%)
0	35	100.0%

amount_due
Real number (ℝ)

Constant Zeros

Distinct	1
Distinct (%)	2.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0

Minimum	0
Maximum	0
Zeros	35
Zeros (%)	100.0%
Negative	0
Negative (%)	0.0%
Memory size	408.0 B

Quantile statistics
Minimum 0
5-th percentile 0
Q1 0
median 0
Q3 0
95-th percentile 0
Maximum 0
Range 0
Interquartile range (IQR) 0

Descriptive statistics
Standard deviation 0
Coefficient of variation (CV) nan
Kurtosis 0
Mean 0
Median Absolute Deviation (MAD) 0
Skewness 0
Sum 0
Variance 0
Monotonicity Increasing

Histogram with fixed size bins (bins=1)

Value	Count	Frequency (%)
0	35	100.0%

Value	Count	Frequency (%)
0	35	100.0%

Value	Count	Frequency (%)
0	35	100.0%

__table_name__
Text

Constant

Distinct	1
Distinct (%)	2.9%
Missing	0
Missing (%)	0.0%
Memory size	2.3 KiB

Length
Max length 8
Median length 8
Mean length 8
Min length 8

Characters and Unicode
Total characters 280
Distinct characters 7
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row invoices
2nd row invoices
3rd row invoices
4th row invoices
5th row invoices

Value	Count	Frequency (%)
invoices	35	100.0%

Most occurring characters

Value	Count	Frequency (%)
i	70	25.0%
n	35	12.5%
v	35	12.5%
o	35	12.5%
c	35	12.5%
e	35	12.5%
s	35	12.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	280	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	70	25.0%
n	35	12.5%
v	35	12.5%
o	35	12.5%
c	35	12.5%
e	35	12.5%
s	35	12.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	280	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	70	25.0%
n	35	12.5%
v	35	12.5%
o	35	12.5%
c	35	12.5%
e	35	12.5%
s	35	12.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	280	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	70	25.0%
n	35	12.5%
v	35	12.5%
o	35	12.5%
c	35	12.5%
e	35	12.5%
s	35	12.5%

Table: order_details

Profile: order_details

Overview

Brought to you by YData

Dataset statistics
Number of variables 11
Number of observations 58
Missing cells 103
Missing cells (%) 16.1%
Total size in memory 9.0 KiB
Average record size in memory 158.2 B

Variable types
Numeric 9
Unsupported 1
Text 1

Alerts

`discount` has constant value "0.0"	Constant
`__table_name__` has constant value "order_details"	Constant
`date_allocated` has 58 (100.0%) missing values	Missing
`purchase_order_id` has 43 (74.1%) missing values	Missing
`inventory_id` has 2 (3.4%) missing values	Missing
`id` has unique values	Unique
`date_allocated` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`quantity` has 2 (3.4%) zeros	Zeros
`discount` has 58 (100.0%) zeros	Zeros
`status_id` has 1 (1.7%) zeros	Zeros

Reproduction
Analysis started 2025-10-30 16:47:18.326757
Analysis finished 2025-10-30 16:47:18.394582
Duration 0.07 seconds
Software version ydata-profiling vv4.17.0
Download configuration config.json

id
Real number (ℝ)

Unique

Distinct	58
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	57.25862069

Minimum	27
Maximum	91
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	650.0 B

Quantile statistics
Minimum 27
5-th percentile 29.85
Q1 41.25
median 55.5
Q3 73.75
95-th percentile 85.15
Maximum 91
Range 64
Interquartile range (IQR) 32.5

Descriptive statistics
Standard deviation 18.77901063
Coefficient of variation (CV) 0.3279682675
Kurtosis -1.250614934
Mean 57.25862069
Median Absolute Deviation (MAD) 16.5
Skewness 0.08662698586
Sum 3321
Variance 352.6512402
Monotonicity Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41	1	1.7%
47	1	1.7%
50	1	1.7%
90	1	1.7%
28	1	1.7%
31	1	1.7%
46	1	1.7%
79	1	1.7%
85	1	1.7%
34	1	1.7%
Other values (48)	48	82.8%

Value	Count	Frequency (%)
27	1	1.7%
28	1	1.7%
29	1	1.7%
30	1	1.7%
31	1	1.7%

Value	Count	Frequency (%)
91	1	1.7%
90	1	1.7%
86	1	1.7%
85	1	1.7%
84	1	1.7%

order_id
Real number (ℝ)

Distinct	40
Distinct (%)	69.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52.36206897

Minimum	30
Maximum	81
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	650.0 B

Quantile statistics
Minimum 30
5-th percentile 31
Q1 40.25
median 47.5
Q3 68.5
95-th percentile 79.15
Maximum 81
Range 51
Interquartile range (IQR) 28.25

Descriptive statistics
Standard deviation 16.39073152
Coefficient of variation (CV) 0.3130268121
Kurtosis -1.176261734
Mean 52.36206897
Median Absolute Deviation (MAD) 12
Skewness 0.4114286915
Sum 3037
Variance 268.6560799
Monotonicity Not monotonic

Histogram with fixed size bins (bins=40)

Value	Count	Frequency (%)
44	3	5.2%
31	3	5.2%
51	3	5.2%
42	3	5.2%
58	2	3.4%
30	2	3.4%
81	2	3.4%
43	2	3.4%
63	2	3.4%
79	2	3.4%
Other values (30)	34	58.6%

Value	Count	Frequency (%)
30	2	3.4%
31	3	5.2%
32	2	3.4%
33	1	1.7%
34	1	1.7%

Value	Count	Frequency (%)
81	2	3.4%
80	1	1.7%
79	2	3.4%
78	1	1.7%
77	1	1.7%

product_id
Real number (ℝ)

Distinct	24
Distinct (%)	41.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.55172414

Minimum	1
Maximum	81
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	650.0 B

Quantile statistics
Minimum 1
5-th percentile 3.85
Q1 17.5
median 41
Q3 51.75
95-th percentile 81
Maximum 81
Range 80
Interquartile range (IQR) 34.25

Descriptive statistics
Standard deviation 25.7308419
Coefficient of variation (CV) 0.6674368651
Kurtosis -1.042721847
Mean 38.55172414
Median Absolute Deviation (MAD) 22
Skewness 0.1803742112
Sum 2236
Variance 662.076225
Monotonicity Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
43	5	8.6%
48	5	8.6%
81	4	6.9%
80	4	6.9%
19	4	6.9%
8	4	6.9%
41	4	6.9%
34	3	5.2%
40	3	5.2%
56	2	3.4%
Other values (14)	20	34.5%

Value	Count	Frequency (%)
1	2	3.4%
3	1	1.7%
4	2	3.4%
5	1	1.7%
6	2	3.4%

Value	Count	Frequency (%)
81	4	6.9%
80	4	6.9%
74	1	1.7%
72	2	3.4%
57	1	1.7%

quantity
Real number (ℝ)

Zeros

Distinct	16
Distinct (%)	27.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	50.72413793

Minimum	0
Maximum	300
Zeros	2
Zeros (%)	3.4%
Negative	0
Negative (%)	0.0%
Memory size	592.0 B

Quantile statistics
Minimum 0
5-th percentile 4.7
Q1 15
median 27.5
Q3 47.5
95-th percentile 215
Maximum 300
Range 300
Interquartile range (IQR) 32.5

Descriptive statistics
Standard deviation 70.63143605
Coefficient of variation (CV) 1.392462029
Kurtosis 6.752549665
Mean 50.72413793
Median Absolute Deviation (MAD) 15
Skewness 2.680008748
Sum 2942
Variance 4988.799758
Monotonicity Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
10	10	17.2%
30	7	12.1%
40	7	12.1%
25	6	10.3%
20	6	10.3%
50	5	8.6%
100	3	5.2%
300	3	5.2%
15	2	3.4%
0	2	3.4%
Other values (6)	7	12.1%

Value	Count	Frequency (%)
0	2	3.4%
3	1	1.7%
5	1	1.7%
10	10	17.2%
15	2	3.4%

Value	Count	Frequency (%)
300	3	5.2%
200	2	3.4%
100	3	5.2%
90	1	1.7%
87	1	1.7%

unit_price
Real number (ℝ)

Distinct	22
Distinct (%)	37.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.27172414

Minimum	2.99
Maximum	81
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	592.0 B

Quantile statistics
Minimum 2.99
5-th percentile 2.99
Q1 9.65
median 18
Q3 37.2
95-th percentile 47.05
Maximum 81
Range 78.01
Interquartile range (IQR) 27.55

Descriptive statistics
Standard deviation 16.90205688
Coefficient of variation (CV) 0.7589020399
Kurtosis 0.9822667559
Mean 22.27172414
Median Absolute Deviation (MAD) 8.8
Skewness 1.051584481
Sum 1291.76
Variance 285.6795268
Monotonicity Increasing

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
46	5	8.6%
12.75	5	8.6%
9.2	4	6.9%
9.65	4	6.9%
2.99	4	6.9%
3.5	4	6.9%
40	4	6.9%
10	3	5.2%
18.4	3	5.2%
14	3	5.2%
Other values (12)	19	32.8%

Value	Count	Frequency (%)
2.99	4	6.9%
3.5	4	6.9%
7	1	1.7%
9.2	4	6.9%
9.65	4	6.9%

Value	Count	Frequency (%)
81	1	1.7%
53	2	3.4%
46	5	8.6%
40	4	6.9%
39	1	1.7%

discount
Real number (ℝ)

Constant Zeros

Distinct	1
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0

Minimum	0
Maximum	0
Zeros	58
Zeros (%)	100.0%
Negative	0
Negative (%)	0.0%
Memory size	592.0 B

Quantile statistics
Minimum 0
5-th percentile 0
Q1 0
median 0
Q3 0
95-th percentile 0
Maximum 0
Range 0
Interquartile range (IQR) 0

Descriptive statistics
Standard deviation 0
Coefficient of variation (CV) nan
Kurtosis 0
Mean 0
Median Absolute Deviation (MAD) 0
Skewness 0
Sum 0
Variance 0
Monotonicity Increasing

Histogram with fixed size bins (bins=1)

Value	Count	Frequency (%)
0	58	100.0%

Value	Count	Frequency (%)
0	58	100.0%

Value	Count	Frequency (%)
0	58	100.0%

status_id
Real number (ℝ)

Zeros

Distinct	4
Distinct (%)	6.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.896551724

Minimum	0
Maximum	5
Zeros	1
Zeros (%)	1.7%
Negative	0
Negative (%)	0.0%
Memory size	650.0 B

Quantile statistics
Minimum 0
5-th percentile 1
Q1 2
median 2
Q3 2
95-th percentile 2
Maximum 5
Range 5
Interquartile range (IQR) 0

Descriptive statistics
Standard deviation 0.5830848144
Coefficient of variation (CV) 0.3074447203
Kurtosis 15.42312292
Mean 1.896551724
Median Absolute Deviation (MAD) 0
Skewness 1.657035387
Sum 110
Variance 0.3399879008
Monotonicity Not monotonic

Histogram with fixed size bins (bins=4)

Value	Count	Frequency (%)
2	49	84.5%
1	7	12.1%
5	1	1.7%
0	1	1.7%

Value	Count	Frequency (%)
0	1	1.7%
1	7	12.1%
2	49	84.5%
5	1	1.7%

Value	Count	Frequency (%)
5	1	1.7%
2	49	84.5%
1	7	12.1%
0	1	1.7%

date_allocated
Unsupported

Missing Rejected Unsupported

Missing	58
Missing (%)	100.0%
Memory size	592.0 B

purchase_order_id
Real number (ℝ)

Missing

Distinct	15
Distinct (%)	100.0%
Missing	43
Missing (%)	74.1%
Infinite	0
Infinite (%)	0.0%
Mean	103.0666667

Minimum	96
Maximum	111
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	650.0 B

Quantile statistics
Minimum 96
5-th percentile 96.7
Q1 99.5
median 103
Q3 106.5
95-th percentile 109.6
Maximum 111
Range 15
Interquartile range (IQR) 7

Descriptive statistics
Standard deviation 4.589843861
Coefficient of variation (CV) 0.04453276708
Kurtosis -1.043102067
Mean 103.0666667
Median Absolute Deviation (MAD) 4
Skewness 0.09376784045
Sum 1546
Variance 21.06666667
Monotonicity Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
101	1	1.7%
103	1	1.7%
97	1	1.7%
98	1	1.7%
104	1	1.7%
100	1	1.7%
109	1	1.7%
111	1	1.7%
96	1	1.7%
105	1	1.7%
Other values (5)	5	8.6%
(Missing)	43	74.1%

Value	Count	Frequency (%)
96	1	1.7%
97	1	1.7%
98	1	1.7%
99	1	1.7%
100	1	1.7%

Value	Count	Frequency (%)
111	1	1.7%
109	1	1.7%
108	1	1.7%
107	1	1.7%
106	1	1.7%

inventory_id
Real number (ℝ)

Missing

Distinct	56
Distinct (%)	100.0%
Missing	2
Missing (%)	3.4%
Infinite	0
Infinite (%)	0.0%
Mean	100.8035714

Minimum	63
Maximum	136
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	650.0 B

Quantile statistics
Minimum 63
5-th percentile 65.75
Q1 82.5
median 100
Q3 122.25
95-th percentile 133.25
Maximum 136
Range 73
Interquartile range (IQR) 39.75

Descriptive statistics
Standard deviation 23.27262898
Coefficient of variation (CV) 0.2308710758
Kurtosis -1.386079178
Mean 100.8035714
Median Absolute Deviation (MAD) 21
Skewness -0.0788302645
Sum 5645
Variance 541.6152597
Monotonicity Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
87	1	1.7%
90	1	1.7%
63	1	1.7%
66	1	1.7%
86	1	1.7%
129	1	1.7%
135	1	1.7%
73	1	1.7%
69	1	1.7%
110	1	1.7%
Other values (46)	46	79.3%
(Missing)	2	3.4%

Value	Count	Frequency (%)
63	1	1.7%
64	1	1.7%
65	1	1.7%
66	1	1.7%
67	1	1.7%

Value	Count	Frequency (%)
136	1	1.7%
135	1	1.7%
134	1	1.7%
133	1	1.7%
132	1	1.7%

__table_name__
Text

Constant

Distinct	1
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	4.1 KiB

Length
Max length 13
Median length 13
Mean length 13
Min length 13

Characters and Unicode
Total characters 754
Distinct characters 10
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row order_details
2nd row order_details
3rd row order_details
4th row order_details
5th row order_details

Value	Count	Frequency (%)
order_details	58	100.0%

Most occurring characters

Value	Count	Frequency (%)
r	116	15.4%
d	116	15.4%
e	116	15.4%
o	58	7.7%
_	58	7.7%
t	58	7.7%
a	58	7.7%
i	58	7.7%
l	58	7.7%
s	58	7.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	754	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	116	15.4%
d	116	15.4%
e	116	15.4%
o	58	7.7%
_	58	7.7%
t	58	7.7%
a	58	7.7%
i	58	7.7%
l	58	7.7%
s	58	7.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	754	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	116	15.4%
d	116	15.4%
e	116	15.4%
o	58	7.7%
_	58	7.7%
t	58	7.7%
a	58	7.7%
i	58	7.7%
l	58	7.7%
s	58	7.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	754	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	116	15.4%
d	116	15.4%
e	116	15.4%
o	58	7.7%
_	58	7.7%
t	58	7.7%
a	58	7.7%
i	58	7.7%
l	58	7.7%
s	58	7.7%

Table: order_details_status

Profile: order_details_status

Overview

Brought to you by YData

Dataset statistics
Number of variables 3
Number of observations 6
Missing cells 0
Missing cells (%) 0.0%
Total size in memory 1.0 KiB
Average record size in memory 171.7 B

Variable types
Numeric 1
Text 2

Alerts

`__table_name__` has constant value "order_details_status"	Constant
`id` has unique values	Unique
`status` has unique values	Unique
`id` has 1 (16.7%) zeros	Zeros

Reproduction
Analysis started 2025-10-30 16:47:20.929487
Analysis finished 2025-10-30 16:47:20.968764
Duration 0.04 seconds
Software version ydata-profiling vv4.17.0
Download configuration config.json

id
Real number (ℝ)

Unique Zeros

Distinct	6
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.5

Minimum	0
Maximum	5
Zeros	1
Zeros (%)	16.7%
Negative	0
Negative (%)	0.0%
Memory size	182.0 B

Quantile statistics
Minimum 0
5-th percentile 0.25
Q1 1.25
median 2.5
Q3 3.75
95-th percentile 4.75
Maximum 5
Range 5
Interquartile range (IQR) 2.5

Descriptive statistics
Standard deviation 1.870828693
Coefficient of variation (CV) 0.7483314774
Kurtosis -1.2
Mean 2.5
Median Absolute Deviation (MAD) 1.5
Skewness 0
Sum 15
Variance 3.5
Monotonicity Strictly increasing

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	1	16.7%
1	1	16.7%
2	1	16.7%
3	1	16.7%
4	1	16.7%
5	1	16.7%

Value	Count	Frequency (%)
0	1	16.7%
1	1	16.7%
2	1	16.7%
3	1	16.7%
4	1	16.7%

Value	Count	Frequency (%)
5	1	16.7%
4	1	16.7%
3	1	16.7%
2	1	16.7%
1	1	16.7%

status
Text

Unique

Distinct	6
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	514.0 B

Length
Max length 9
Median length 8.5
Mean length 7.333333333
Min length 4

Characters and Unicode
Total characters 44
Distinct characters 20
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 6 ?
Unique (%) 100.0%

Sample
1st row None
2nd row Allocated
3rd row Invoiced
4th row Shipped
5th row On Order

Value	Count	Frequency (%)
none	1	12.5%
allocated	1	12.5%
invoiced	1	12.5%
shipped	1	12.5%
on	1	12.5%
order	1	12.5%
no	1	12.5%
stock	1	12.5%

Most occurring characters

Value	Count	Frequency (%)
o	5	11.4%
e	5	11.4%
d	4	9.1%
n	3	6.8%
c	3	6.8%
N	2	4.5%
t	2	4.5%
l	2	4.5%
O	2	4.5%
p	2	4.5%
Other values (10)	14	31.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	44	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	5	11.4%
e	5	11.4%
d	4	9.1%
n	3	6.8%
c	3	6.8%
N	2	4.5%
t	2	4.5%
l	2	4.5%
O	2	4.5%
p	2	4.5%
Other values (10)	14	31.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	44	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	5	11.4%
e	5	11.4%
d	4	9.1%
n	3	6.8%
c	3	6.8%
N	2	4.5%
t	2	4.5%
l	2	4.5%
O	2	4.5%
p	2	4.5%
Other values (10)	14	31.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	44	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	5	11.4%
e	5	11.4%
d	4	9.1%
n	3	6.8%
c	3	6.8%
N	2	4.5%
t	2	4.5%
l	2	4.5%
O	2	4.5%
p	2	4.5%
Other values (10)	14	31.8%

__table_name__
Text

Constant

Distinct	1
Distinct (%)	16.7%
Missing	0
Missing (%)	0.0%
Memory size	590.0 B

Length
Max length 20
Median length 20
Mean length 20
Min length 20

Characters and Unicode
Total characters 120
Distinct characters 11
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row order_details_status
2nd row order_details_status
3rd row order_details_status
4th row order_details_status
5th row order_details_status

Value	Count	Frequency (%)
order_details_status	6	100.0%

Most occurring characters

Value	Count	Frequency (%)
t	18	15.0%
s	18	15.0%
r	12	10.0%
a	12	10.0%
d	12	10.0%
_	12	10.0%
e	12	10.0%
o	6	5.0%
i	6	5.0%
l	6	5.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	120	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	18	15.0%
s	18	15.0%
r	12	10.0%
a	12	10.0%
d	12	10.0%
_	12	10.0%
e	12	10.0%
o	6	5.0%
i	6	5.0%
l	6	5.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	120	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	18	15.0%
s	18	15.0%
r	12	10.0%
a	12	10.0%
d	12	10.0%
_	12	10.0%
e	12	10.0%
o	6	5.0%
i	6	5.0%
l	6	5.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	120	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	18	15.0%
s	18	15.0%
r	12	10.0%
a	12	10.0%
d	12	10.0%
_	12	10.0%
e	12	10.0%
o	6	5.0%
i	6	5.0%
l	6	5.0%

Table: orders

Profile: orders

Overview

Brought to you by YData

Dataset statistics
Number of variables 21
Number of observations 48
Missing cells 130
Missing cells (%) 12.9%
Total size in memory 30.1 KiB
Average record size in memory 642.2 B

Variable types
Numeric 8
DateTime 3
Text 8
Unsupported 2

Alerts

`ship_zip_postal_code` has constant value "99999"	Constant
`ship_country_region` has constant value "USA"	Constant
`taxes` has constant value "0.0"	Constant
`tax_rate` has constant value "0.0"	Constant
`__table_name__` has constant value "orders"	Constant
`shipped_date` has 9 (18.8%) missing values	Missing
`shipper_id` has 5 (10.4%) missing values	Missing
`payment_type` has 10 (20.8%) missing values	Missing
`paid_date` has 10 (20.8%) missing values	Missing
`notes` has 48 (100.0%) missing values	Missing
`tax_status_id` has 48 (100.0%) missing values	Missing
`id` has unique values	Unique
`notes` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`tax_status_id` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`shipping_fee` has 12 (25.0%) zeros	Zeros
`taxes` has 48 (100.0%) zeros	Zeros
`tax_rate` has 48 (100.0%) zeros	Zeros
`status_id` has 16 (33.3%) zeros	Zeros

Reproduction
Analysis started 2025-10-30 16:47:24.733826
Analysis finished 2025-10-30 16:47:24.923709
Duration 0.19 seconds
Software version ydata-profiling vv4.17.0
Download configuration config.json

id
Real number (ℝ)

Unique

Distinct	48
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	55.79166667

Minimum	30
Maximum	81
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	560.0 B

Quantile statistics
Minimum 30
5-th percentile 32.35
Q1 41.75
median 57.5
Q3 69.25
95-th percentile 78.65
Maximum 81
Range 51
Interquartile range (IQR) 27.5

Descriptive statistics
Standard deviation 15.74120265
Coefficient of variation (CV) 0.282142542
Kurtosis -1.331045073
Mean 55.79166667
Median Absolute Deviation (MAD) 14
Skewness -0.05609480355
Sum 2678
Variance 247.785461
Monotonicity Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
32	1	2.1%
30	1	2.1%
31	1	2.1%
34	1	2.1%
33	1	2.1%
72	1	2.1%
65	1	2.1%
38	1	2.1%
45	1	2.1%
71	1	2.1%
Other values (38)	38	79.2%

Value	Count	Frequency (%)
30	1	2.1%
31	1	2.1%
32	1	2.1%
33	1	2.1%
34	1	2.1%

Value	Count	Frequency (%)
81	1	2.1%
80	1	2.1%
79	1	2.1%
78	1	2.1%
77	1	2.1%

employee_id
Real number (ℝ)

Distinct	8
Distinct (%)	16.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.458333333

Minimum	1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	560.0 B

Quantile statistics
Minimum 1
5-th percentile 1
Q1 1.75
median 4
Q3 7.25
95-th percentile 9
Maximum 9
Range 8
Interquartile range (IQR) 5.5

Descriptive statistics
Standard deviation 3.045459357
Coefficient of variation (CV) 0.6830936875
Kurtosis -1.356336556
Mean 4.458333333
Median Absolute Deviation (MAD) 3
Skewness 0.3914266675
Sum 214
Variance 9.274822695
Monotonicity Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
1	12	25.0%
9	10	20.8%
4	8	16.7%
3	6	12.5%
6	4	8.3%
2	4	8.3%
8	2	4.2%
7	2	4.2%

Value	Count	Frequency (%)
1	12	25.0%
2	4	8.3%
3	6	12.5%
4	8	16.7%
6	4	8.3%

Value	Count	Frequency (%)
9	10	20.8%
8	2	4.2%
7	2	4.2%
6	4	8.3%
4	8	16.7%

customer_id
Real number (ℝ)

Distinct	15
Distinct (%)	31.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.85416667

Minimum	1
Maximum	29
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	560.0 B

Quantile statistics
Minimum 1
5-th percentile 3
Q1 6
median 8.5
Q3 25.25
95-th percentile 29
Maximum 29
Range 28
Interquartile range (IQR) 19.25

Descriptive statistics
Standard deviation 9.815293285
Coefficient of variation (CV) 0.7635884565
Kurtosis -1.159827679
Mean 12.85416667
Median Absolute Deviation (MAD) 4
Skewness 0.7421208642
Sum 617
Variance 96.33998227
Monotonicity Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
8	6	12.5%
6	6	12.5%
4	5	10.4%
28	4	8.3%
10	4	8.3%
29	4	8.3%
3	3	6.2%
1	2	4.2%
27	2	4.2%
12	2	4.2%
Other values (5)	10	20.8%

Value	Count	Frequency (%)
1	2	4.2%
3	3	6.2%
4	5	10.4%
6	6	12.5%
7	2	4.2%

Value	Count	Frequency (%)
29	4	8.3%
28	4	8.3%
27	2	4.2%
26	2	4.2%
25	2	4.2%

order_date
Date

Distinct	28
Distinct (%)	58.3%
Missing	0
Missing (%)	0.0%
Memory size	512.0 B

Minimum	2006-01-15 00:00:00
Maximum	2006-06-23 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=28)

shipped_date
Date

Missing

Distinct	23
Distinct (%)	59.0%
Missing	9
Missing (%)	18.8%
Memory size	512.0 B

Minimum	2006-01-22 00:00:00
Maximum	2006-06-23 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=23)

shipper_id
Real number (ℝ)

Missing

Distinct	3
Distinct (%)	7.0%
Missing	5
Missing (%)	10.4%
Infinite	0
Infinite (%)	0.0%
Mean	2.209302326

Minimum	1
Maximum	3
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	560.0 B

Quantile statistics
Minimum 1
5-th percentile 1
Q1 2
median 2
Q3 3
95-th percentile 3
Maximum 3
Range 2
Interquartile range (IQR) 1

Descriptive statistics
Standard deviation 0.7418811205
Coefficient of variation (CV) 0.3357988229
Kurtosis -1.069775714
Mean 2.209302326
Median Absolute Deviation (MAD) 1
Skewness -0.3613737778
Sum 95
Variance 0.5503875969
Monotonicity Not monotonic

Histogram with fixed size bins (bins=3)

Value	Count	Frequency (%)
2	18	37.5%
3	17	35.4%
1	8	16.7%
(Missing)	5	10.4%

Value	Count	Frequency (%)
1	8	16.7%
2	18	37.5%
3	17	35.4%

Value	Count	Frequency (%)
3	17	35.4%
2	18	37.5%
1	8	16.7%

ship_name
Text

Distinct	15
Distinct (%)	31.2%
Missing	0
Missing (%)	0.0%
Memory size	3.7 KiB

Length
Max length 22
Median length 16
Mean length 14.20833333
Min length 7

Characters and Unicode
Total characters 682
Distinct characters 41
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row John Edwards
2nd row Karen Toh
3rd row Christina Lee
4th row Christina Lee
5th row Elizabeth Andersen

Value	Count	Frequency (%)
lee	9	9.0%
andersen	6	6.0%
francisco	6	6.0%
pérez-olaeta	6	6.0%
elizabeth	6	6.0%
christina	5	5.0%
amritansh	4	4.0%
raghav	4	4.0%
roland	4	4.0%
wacker	4	4.0%
Other values (19)	46	46.0%

Most occurring characters

Value	Count	Frequency (%)
e	75	11.0%
n	64	9.4%
a	62	9.1%
	52	7.6%
r	41	6.0%
s	32	4.7%
i	32	4.7%
o	31	4.5%
h	30	4.4%
t	25	3.7%
Other values (31)	238	34.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	682	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	75	11.0%
n	64	9.4%
a	62	9.1%
	52	7.6%
r	41	6.0%
s	32	4.7%
i	32	4.7%
o	31	4.5%
h	30	4.4%
t	25	3.7%
Other values (31)	238	34.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	682	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	75	11.0%
n	64	9.4%
a	62	9.1%
	52	7.6%
r	41	6.0%
s	32	4.7%
i	32	4.7%
o	31	4.5%
h	30	4.4%
t	25	3.7%
Other values (31)	238	34.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	682	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	75	11.0%
n	64	9.4%
a	62	9.1%
	52	7.6%
r	41	6.0%
s	32	4.7%
i	32	4.7%
o	31	4.5%
h	30	4.4%
t	25	3.7%
Other values (31)	238	34.9%

ship_address
Text

Distinct	15
Distinct (%)	31.2%
Missing	0
Missing (%)	0.0%
Memory size	3.5 KiB

Length
Max length 15
Median length 14
Mean length 14.45833333
Min length 14

Characters and Unicode
Total characters 694
Distinct characters 18
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row 123 12th Street
2nd row 789 27th Street
3rd row 123 4th Street
4th row 123 4th Street
5th row 123 8th Street

Value	Count	Frequency (%)
street	48	33.3%
123	34	23.6%
789	14	9.7%
8th	6	4.2%
6th	6	4.2%
4th	5	3.5%
28th	4	2.8%
10th	4	2.8%
29th	4	2.8%
3rd	3	2.1%
Other values (8)	16	11.1%

Most occurring characters

Value	Count	Frequency (%)
t	141	20.3%
	96	13.8%
e	96	13.8%
r	51	7.3%
2	50	7.2%
S	48	6.9%
1	46	6.6%
h	43	6.2%
3	37	5.3%
8	24	3.5%
Other values (8)	62	8.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	694	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	141	20.3%
	96	13.8%
e	96	13.8%
r	51	7.3%
2	50	7.2%
S	48	6.9%
1	46	6.6%
h	43	6.2%
3	37	5.3%
8	24	3.5%
Other values (8)	62	8.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	694	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	141	20.3%
	96	13.8%
e	96	13.8%
r	51	7.3%
2	50	7.2%
S	48	6.9%
1	46	6.6%
h	43	6.2%
3	37	5.3%
8	24	3.5%
Other values (8)	62	8.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	694	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	141	20.3%
	96	13.8%
e	96	13.8%
r	51	7.3%
2	50	7.2%
S	48	6.9%
1	46	6.6%
h	43	6.2%
3	37	5.3%
8	24	3.5%
Other values (8)	62	8.9%

ship_city
Text

Distinct	12
Distinct (%)	25.0%
Missing	0
Missing (%)	0.0%
Memory size	3.2 KiB

Length
Max length 14
Median length 9
Mean length 7.854166667
Min length 5

Characters and Unicode
Total characters 377
Distinct characters 32
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row Las Vegas
2nd row Las Vegas
3rd row New York
4th row New York
5th row Portland

Value	Count	Frequency (%)
portland	6	9.4%
milwaukee	6	9.4%
chicago	6	9.4%
new	5	7.8%
york	5	7.8%
memphis	4	6.2%
las	4	6.2%
vegas	4	6.2%
denver	4	6.2%
miami	4	6.2%
Other values (7)	16	25.0%

Most occurring characters

Value	Count	Frequency (%)
e	44	11.7%
a	39	10.3%
i	28	7.4%
o	22	5.8%
s	20	5.3%
l	19	5.0%
	16	4.2%
r	15	4.0%
t	14	3.7%
M	14	3.7%
Other values (22)	146	38.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	377	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	44	11.7%
a	39	10.3%
i	28	7.4%
o	22	5.8%
s	20	5.3%
l	19	5.0%
	16	4.2%
r	15	4.0%
t	14	3.7%
M	14	3.7%
Other values (22)	146	38.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	377	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	44	11.7%
a	39	10.3%
i	28	7.4%
o	22	5.8%
s	20	5.3%
l	19	5.0%
	16	4.2%
r	15	4.0%
t	14	3.7%
M	14	3.7%
Other values (22)	146	38.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	377	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	44	11.7%
a	39	10.3%
i	28	7.4%
o	22	5.8%
s	20	5.3%
l	19	5.0%
	16	4.2%
r	15	4.0%
t	14	3.7%
M	14	3.7%
Other values (22)	146	38.7%

ship_state_province
Text

Distinct	12
Distinct (%)	25.0%
Missing	0
Missing (%)	0.0%
Memory size	2.9 KiB

Length
Max length 2
Median length 2
Mean length 2
Min length 2

Characters and Unicode
Total characters 96
Distinct characters 14
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row NV
2nd row NV
3rd row NY
4th row NY
5th row OR

Value	Count	Frequency (%)
or	6	12.5%
wi	6	12.5%
il	6	12.5%
ny	5	10.4%
tn	4	8.3%
nv	4	8.3%
co	4	8.3%
fl	4	8.3%
ca	3	6.2%
wa	2	4.2%
Other values (2)	4	8.3%

Most occurring characters

Value	Count	Frequency (%)
I	14	14.6%
N	13	13.5%
L	10	10.4%
O	10	10.4%
W	8	8.3%
C	7	7.3%
R	6	6.2%
T	6	6.2%
Y	5	5.2%
A	5	5.2%
Other values (4)	12	12.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	96	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
I	14	14.6%
N	13	13.5%
L	10	10.4%
O	10	10.4%
W	8	8.3%
C	7	7.3%
R	6	6.2%
T	6	6.2%
Y	5	5.2%
A	5	5.2%
Other values (4)	12	12.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	96	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
I	14	14.6%
N	13	13.5%
L	10	10.4%
O	10	10.4%
W	8	8.3%
C	7	7.3%
R	6	6.2%
T	6	6.2%
Y	5	5.2%
A	5	5.2%
Other values (4)	12	12.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	96	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
I	14	14.6%
N	13	13.5%
L	10	10.4%
O	10	10.4%
W	8	8.3%
C	7	7.3%
R	6	6.2%
T	6	6.2%
Y	5	5.2%
A	5	5.2%
Other values (4)	12	12.5%

ship_zip_postal_code
Text

Constant

Distinct	1
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Memory size	3.0 KiB

Length
Max length 5
Median length 5
Mean length 5
Min length 5

Characters and Unicode
Total characters 240
Distinct characters 1
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row 99999
2nd row 99999
3rd row 99999
4th row 99999
5th row 99999

Value	Count	Frequency (%)
99999	48	100.0%

Most occurring characters

Value	Count	Frequency (%)
9	240	100.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	240	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
9	240	100.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	240	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
9	240	100.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	240	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
9	240	100.0%

ship_country_region
Text

Constant

Distinct	1
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Memory size	2.9 KiB

Length
Max length 3
Median length 3
Mean length 3
Min length 3

Characters and Unicode
Total characters 144
Distinct characters 3
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row USA
2nd row USA
3rd row USA
4th row USA
5th row USA

Value	Count	Frequency (%)
usa	48	100.0%

Most occurring characters

Value	Count	Frequency (%)
U	48	33.3%
S	48	33.3%
A	48	33.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	144	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
U	48	33.3%
S	48	33.3%
A	48	33.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	144	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
U	48	33.3%
S	48	33.3%
A	48	33.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	144	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
U	48	33.3%
S	48	33.3%
A	48	33.3%

shipping_fee
Real number (ℝ)

Zeros

Distinct	13
Distinct (%)	27.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	44.54166667

Minimum	0
Maximum	300
Zeros	12
Zeros (%)	25.0%
Negative	0
Negative (%)	0.0%
Memory size	512.0 B

Quantile statistics
Minimum 0
5-th percentile 0
Q1 3
median 7
Q3 50
95-th percentile 200
Maximum 300
Range 300
Interquartile range (IQR) 47

Descriptive statistics
Standard deviation 78.04089444
Coefficient of variation (CV) 1.752087434
Kurtosis 3.942468244
Mean 44.54166667
Median Absolute Deviation (MAD) 7
Skewness 2.175695331
Sum 2138
Variance 6090.381206
Monotonicity Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
0	12	25.0%
5	8	16.7%
200	4	8.3%
7	4	8.3%
50	4	8.3%
40	2	4.2%
4	2	4.2%
12	2	4.2%
10	2	4.2%
300	2	4.2%
Other values (3)	6	12.5%

Value	Count	Frequency (%)
0	12	25.0%
4	2	4.2%
5	8	16.7%
7	4	8.3%
9	2	4.2%

Value	Count	Frequency (%)
300	2	4.2%
200	4	8.3%
100	2	4.2%
60	2	4.2%
50	4	8.3%

taxes
Real number (ℝ)

Constant Zeros

Distinct	1
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0

Minimum	0
Maximum	0
Zeros	48
Zeros (%)	100.0%
Negative	0
Negative (%)	0.0%
Memory size	512.0 B

Quantile statistics
Minimum 0
5-th percentile 0
Q1 0
median 0
Q3 0
95-th percentile 0
Maximum 0
Range 0
Interquartile range (IQR) 0

Descriptive statistics
Standard deviation 0
Coefficient of variation (CV) nan
Kurtosis 0
Mean 0
Median Absolute Deviation (MAD) 0
Skewness 0
Sum 0
Variance 0
Monotonicity Increasing

Histogram with fixed size bins (bins=1)

Value	Count	Frequency (%)
0	48	100.0%

Value	Count	Frequency (%)
0	48	100.0%

Value	Count	Frequency (%)
0	48	100.0%

payment_type
Text

Missing

Distinct	3
Distinct (%)	7.9%
Missing	10
Missing (%)	20.8%
Memory size	2.8 KiB

Length
Max length 11
Median length 5
Mean length 7.421052632
Min length 4

Characters and Unicode
Total characters 282
Distinct characters 12
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row Credit Card
2nd row Check
3rd row Credit Card
4th row Check
5th row Credit Card

Value	Count	Frequency (%)
check	18	33.3%
credit	16	29.6%
card	16	29.6%
cash	4	7.4%

Most occurring characters

Value	Count	Frequency (%)
C	54	19.1%
e	34	12.1%
d	32	11.3%
r	32	11.3%
h	22	7.8%
a	20	7.1%
c	18	6.4%
k	18	6.4%
i	16	5.7%
t	16	5.7%
Other values (2)	20	7.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	282	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
C	54	19.1%
e	34	12.1%
d	32	11.3%
r	32	11.3%
h	22	7.8%
a	20	7.1%
c	18	6.4%
k	18	6.4%
i	16	5.7%
t	16	5.7%
Other values (2)	20	7.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	282	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
C	54	19.1%
e	34	12.1%
d	32	11.3%
r	32	11.3%
h	22	7.8%
a	20	7.1%
c	18	6.4%
k	18	6.4%
i	16	5.7%
t	16	5.7%
Other values (2)	20	7.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	282	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
C	54	19.1%
e	34	12.1%
d	32	11.3%
r	32	11.3%
h	22	7.8%
a	20	7.1%
c	18	6.4%
k	18	6.4%
i	16	5.7%
t	16	5.7%
Other values (2)	20	7.1%

paid_date
Date

Missing

Distinct	26
Distinct (%)	68.4%
Missing	10
Missing (%)	20.8%
Memory size	512.0 B

Minimum	2006-01-15 00:00:00
Maximum	2006-06-23 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=26)

notes
Unsupported

Missing Rejected Unsupported

Missing	48
Missing (%)	100.0%
Memory size	512.0 B

tax_rate
Real number (ℝ)

Constant Zeros

Distinct	1
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0

Minimum	0
Maximum	0
Zeros	48
Zeros (%)	100.0%
Negative	0
Negative (%)	0.0%
Memory size	512.0 B

Quantile statistics
Minimum 0
5-th percentile 0
Q1 0
median 0
Q3 0
95-th percentile 0
Maximum 0
Range 0
Interquartile range (IQR) 0

Descriptive statistics
Standard deviation 0
Coefficient of variation (CV) nan
Kurtosis 0
Mean 0
Median Absolute Deviation (MAD) 0
Skewness 0
Sum 0
Variance 0
Monotonicity Increasing

Histogram with fixed size bins (bins=1)

Value	Count	Frequency (%)
0	48	100.0%

Value	Count	Frequency (%)
0	48	100.0%

Value	Count	Frequency (%)
0	48	100.0%

tax_status_id
Unsupported

Missing Rejected Unsupported

Missing	48
Missing (%)	100.0%
Memory size	560.0 B

status_id
Real number (ℝ)

Zeros

Distinct	3
Distinct (%)	6.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.979166667

Minimum	0
Maximum	3
Zeros	16
Zeros (%)	33.3%
Negative	0
Negative (%)	0.0%
Memory size	560.0 B

Quantile statistics
Minimum 0
5-th percentile 0
Q1 0
median 3
Q3 3
95-th percentile 3
Maximum 3
Range 3
Interquartile range (IQR) 3

Descriptive statistics
Standard deviation 1.421560176
Coefficient of variation (CV) 0.7182619835
Kurtosis -1.548849887
Mean 1.979166667
Median Absolute Deviation (MAD) 0
Skewness -0.7037744749
Sum 95
Variance 2.020833333
Monotonicity Not monotonic

Histogram with fixed size bins (bins=3)

Value	Count	Frequency (%)
3	31	64.6%
0	16	33.3%
2	1	2.1%

Value	Count	Frequency (%)
0	16	33.3%
2	1	2.1%
3	31	64.6%

Value	Count	Frequency (%)
3	31	64.6%
2	1	2.1%
0	16	33.3%

__table_name__
Text

Constant

Distinct	1
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 KiB

Length
Max length 6
Median length 6
Mean length 6
Min length 6

Characters and Unicode
Total characters 288
Distinct characters 5
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row orders
2nd row orders
3rd row orders
4th row orders
5th row orders

Value	Count	Frequency (%)
orders	48	100.0%

Most occurring characters

Value	Count	Frequency (%)
r	96	33.3%
o	48	16.7%
d	48	16.7%
e	48	16.7%
s	48	16.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	288	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	96	33.3%
o	48	16.7%
d	48	16.7%
e	48	16.7%
s	48	16.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	288	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	96	33.3%
o	48	16.7%
d	48	16.7%
e	48	16.7%
s	48	16.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	288	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	96	33.3%
o	48	16.7%
d	48	16.7%
e	48	16.7%
s	48	16.7%

Table: orders_status

Profile: orders_status

Overview

Brought to you by YData

Dataset statistics
Number of variables 3
Number of observations 4
Missing cells 0
Missing cells (%) 0.0%
Total size in memory 696.0 B
Average record size in memory 174.0 B

Variable types
Numeric 1
Text 2

Alerts

`__table_name__` has constant value "orders_status"	Constant
`id` has unique values	Unique
`status_name` has unique values	Unique
`id` has 1 (25.0%) zeros	Zeros

Reproduction
Analysis started 2025-10-30 16:47:30.663506
Analysis finished 2025-10-30 16:47:30.705684
Duration 0.04 seconds
Software version ydata-profiling vv4.17.0
Download configuration config.json

id
Real number (ℝ)

Unique Zeros

Distinct	4
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.5

Minimum	0
Maximum	3
Zeros	1
Zeros (%)	25.0%
Negative	0
Negative (%)	0.0%
Memory size	164.0 B

Quantile statistics
Minimum 0
5-th percentile 0.15
Q1 0.75
median 1.5
Q3 2.25
95-th percentile 2.85
Maximum 3
Range 3
Interquartile range (IQR) 1.5

Descriptive statistics
Standard deviation 1.290994449
Coefficient of variation (CV) 0.8606629658
Kurtosis -1.2
Mean 1.5
Median Absolute Deviation (MAD) 1
Skewness 0
Sum 6
Variance 1.666666667
Monotonicity Strictly increasing

Histogram with fixed size bins (bins=4)

Value	Count	Frequency (%)
0	1	25.0%
1	1	25.0%
2	1	25.0%
3	1	25.0%

Value	Count	Frequency (%)
0	1	25.0%
1	1	25.0%
2	1	25.0%
3	1	25.0%

Value	Count	Frequency (%)
3	1	25.0%
2	1	25.0%
1	1	25.0%
0	1	25.0%

status_name
Text

Unique

Distinct	4
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	380.0 B

Length
Max length 8
Median length 6.5
Mean length 6
Min length 3

Characters and Unicode
Total characters 24
Distinct characters 16
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 4 ?
Unique (%) 100.0%

Sample
1st row New
2nd row Invoiced
3rd row Shipped
4th row Closed

Value	Count	Frequency (%)
new	1	25.0%
invoiced	1	25.0%
shipped	1	25.0%
closed	1	25.0%

Most occurring characters

Value	Count	Frequency (%)
e	4	16.7%
d	3	12.5%
o	2	8.3%
i	2	8.3%
p	2	8.3%
w	1	4.2%
I	1	4.2%
N	1	4.2%
n	1	4.2%
v	1	4.2%
Other values (6)	6	25.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	24	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	4	16.7%
d	3	12.5%
o	2	8.3%
i	2	8.3%
p	2	8.3%
w	1	4.2%
I	1	4.2%
N	1	4.2%
n	1	4.2%
v	1	4.2%
Other values (6)	6	25.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	24	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	4	16.7%
d	3	12.5%
o	2	8.3%
i	2	8.3%
p	2	8.3%
w	1	4.2%
I	1	4.2%
N	1	4.2%
n	1	4.2%
v	1	4.2%
Other values (6)	6	25.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	24	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	4	16.7%
d	3	12.5%
o	2	8.3%
i	2	8.3%
p	2	8.3%
w	1	4.2%
I	1	4.2%
N	1	4.2%
n	1	4.2%
v	1	4.2%
Other values (6)	6	25.0%

__table_name__
Text

Constant

Distinct	1
Distinct (%)	25.0%
Missing	0
Missing (%)	0.0%
Memory size	408.0 B

Length
Max length 13
Median length 13
Mean length 13
Min length 13

Characters and Unicode
Total characters 52
Distinct characters 9
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row orders_status
2nd row orders_status
3rd row orders_status
4th row orders_status

Value	Count	Frequency (%)
orders_status	4	100.0%

Most occurring characters

Value	Count	Frequency (%)
s	12	23.1%
t	8	15.4%
r	8	15.4%
o	4	7.7%
d	4	7.7%
e	4	7.7%
_	4	7.7%
a	4	7.7%
u	4	7.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	52	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
s	12	23.1%
t	8	15.4%
r	8	15.4%
o	4	7.7%
d	4	7.7%
e	4	7.7%
_	4	7.7%
a	4	7.7%
u	4	7.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	52	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
s	12	23.1%
t	8	15.4%
r	8	15.4%
o	4	7.7%
d	4	7.7%
e	4	7.7%
_	4	7.7%
a	4	7.7%
u	4	7.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	52	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
s	12	23.1%
t	8	15.4%
r	8	15.4%
o	4	7.7%
d	4	7.7%
e	4	7.7%
_	4	7.7%
a	4	7.7%
u	4	7.7%

Table: orders_tax_status

Profile: orders_tax_status

Overview

Brought to you by YData

Dataset statistics
Number of variables 3
Number of observations 2
Missing cells 0
Missing cells (%) 0.0%
Total size in memory 425.0 B
Average record size in memory 212.5 B

Variable types
Numeric 1
Text 2

Alerts

`__table_name__` has constant value "orders_tax_status"	Constant
`id` has unique values	Unique
`tax_status_name` has unique values	Unique
`id` has 1 (50.0%) zeros	Zeros

Reproduction
Analysis started 2025-10-30 16:47:32.212133
Analysis finished 2025-10-30 16:47:32.263927
Duration 0.05 seconds
Software version ydata-profiling vv4.17.0
Download configuration config.json

id
Real number (ℝ)

Unique Zeros

Distinct	2
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.5

Minimum	0
Maximum	1
Zeros	1
Zeros (%)	50.0%
Negative	0
Negative (%)	0.0%
Memory size	146.0 B

Quantile statistics
Minimum 0
5-th percentile 0.05
Q1 0.25
median 0.5
Q3 0.75
95-th percentile 0.95
Maximum 1
Range 1
Interquartile range (IQR) 0.5

Descriptive statistics
Histogram with fixed size bins (bins=2)
Standard deviation 0.7071067812
Coefficient of variation (CV) 1.414213562
Kurtosis
Mean 0.5

Median Absolute Deviation (MAD) 0.5

Skewness
Sum 1

Variance 0.5

Monotonicity Strictly increasing

Value Count Frequency (%)
0 1
50.0%
1 1
50.0%

Value	Count	Frequency (%)
0	1	50.0%
1	1	50.0%

Value	Count	Frequency (%)
1	1	50.0%
0	1	50.0%

tax_status_name
Text

Unique

Distinct	2
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	259.0 B

Length
Max length 10
Median length 8.5
Mean length 8.5
Min length 7

Characters and Unicode
Total characters 17
Distinct characters 11
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 2 ?
Unique (%) 100.0%

Sample
1st row Tax Exempt
2nd row Taxable

Value	Count	Frequency (%)
tax	1	33.3%
exempt	1	33.3%
taxable	1	33.3%

Most occurring characters

Value	Count	Frequency (%)
a	3	17.6%
x	3	17.6%
T	2	11.8%
e	2	11.8%
	1	5.9%
E	1	5.9%
m	1	5.9%
p	1	5.9%
t	1	5.9%
b	1	5.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	17	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	3	17.6%
x	3	17.6%
T	2	11.8%
e	2	11.8%
	1	5.9%
E	1	5.9%
m	1	5.9%
p	1	5.9%
t	1	5.9%
b	1	5.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	17	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	3	17.6%
x	3	17.6%
T	2	11.8%
e	2	11.8%
	1	5.9%
E	1	5.9%
m	1	5.9%
p	1	5.9%
t	1	5.9%
b	1	5.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	17	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	3	17.6%
x	3	17.6%
T	2	11.8%
e	2	11.8%
	1	5.9%
E	1	5.9%
m	1	5.9%
p	1	5.9%
t	1	5.9%
b	1	5.9%

__table_name__
Text

Constant

Distinct	1
Distinct (%)	50.0%
Missing	0
Missing (%)	0.0%
Memory size	276.0 B

Length
Max length 17
Median length 17
Mean length 17
Min length 17

Characters and Unicode
Total characters 34
Distinct characters 10
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row orders_tax_status
2nd row orders_tax_status

Value	Count	Frequency (%)
orders_tax_status	2	100.0%

Most occurring characters

Value	Count	Frequency (%)
t	6	17.6%
s	6	17.6%
a	4	11.8%
r	4	11.8%
_	4	11.8%
o	2	5.9%
d	2	5.9%
e	2	5.9%
x	2	5.9%
u	2	5.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	34	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	6	17.6%
s	6	17.6%
a	4	11.8%
r	4	11.8%
_	4	11.8%
o	2	5.9%
d	2	5.9%
e	2	5.9%
x	2	5.9%
u	2	5.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	34	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	6	17.6%
s	6	17.6%
a	4	11.8%
r	4	11.8%
_	4	11.8%
o	2	5.9%
d	2	5.9%
e	2	5.9%
x	2	5.9%
u	2	5.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	34	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	6	17.6%
s	6	17.6%
a	4	11.8%
r	4	11.8%
_	4	11.8%
o	2	5.9%
d	2	5.9%
e	2	5.9%
x	2	5.9%
u	2	5.9%

Table: privileges

Profile: privileges

Overview

Brought to you by YData

Dataset statistics
Number of variables 3
Number of observations 1
Missing cells 0
Missing cells (%) 0.0%
Total size in memory 279.0 B
Average record size in memory 279.0 B

Variable types
Numeric 1
Text 2

Alerts

`id` has constant value "2"	Constant
`privilege_name` has constant value "Purchase Approvals"	Constant
`__table_name__` has constant value "privileges"	Constant
`id` has unique values	Unique
`privilege_name` has unique values	Unique
`__table_name__` has unique values	Unique

Reproduction
Analysis started 2025-10-30 16:47:34.003156
Analysis finished 2025-10-30 16:47:34.052137
Duration 0.05 seconds
Software version ydata-profiling vv4.17.0
Download configuration config.json

id
Real number (ℝ)

Constant Unique

Distinct	1
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2

Minimum	2
Maximum	2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	137.0 B

Quantile statistics
Minimum 2
5-th percentile 2
Q1 2
median 2
Q3 2
95-th percentile 2
Maximum 2
Range 0
Interquartile range (IQR) 0

Value	Count	Frequency (%)
2	1	100.0%

Value	Count	Frequency (%)
2	1	100.0%

privilege_name
Text

Constant Unique

Distinct	1
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	203.0 B

Length
Max length 18
Median length 18
Mean length 18
Min length 18

Characters and Unicode
Total characters 18
Distinct characters 14
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 1 ?
Unique (%) 100.0%

Sample
1st row Purchase Approvals

Value	Count	Frequency (%)
purchase	1	50.0%
approvals	1	50.0%

Most occurring characters

Value	Count	Frequency (%)
a	2	11.1%
r	2	11.1%
p	2	11.1%
s	2	11.1%
u	1	5.6%
P	1	5.6%
h	1	5.6%
c	1	5.6%
	1	5.6%
e	1	5.6%
Other values (4)	4	22.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	18	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	2	11.1%
r	2	11.1%
p	2	11.1%
s	2	11.1%
u	1	5.6%
P	1	5.6%
h	1	5.6%
c	1	5.6%
	1	5.6%
e	1	5.6%
Other values (4)	4	22.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	18	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	2	11.1%
r	2	11.1%
p	2	11.1%
s	2	11.1%
u	1	5.6%
P	1	5.6%
h	1	5.6%
c	1	5.6%
	1	5.6%
e	1	5.6%
Other values (4)	4	22.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	18	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	2	11.1%
r	2	11.1%
p	2	11.1%
s	2	11.1%
u	1	5.6%
P	1	5.6%
h	1	5.6%
c	1	5.6%
	1	5.6%
e	1	5.6%
Other values (4)	4	22.2%

__table_name__
Text

Constant Unique

Distinct	1
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	195.0 B

Length
Max length 10
Median length 10
Mean length 10
Min length 10

Characters and Unicode
Total characters 10
Distinct characters 8
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 1 ?
Unique (%) 100.0%

Sample
1st row privileges

Value	Count	Frequency (%)
privileges	1	100.0%

Most occurring characters

Value	Count	Frequency (%)
i	2	20.0%
e	2	20.0%
r	1	10.0%
p	1	10.0%
v	1	10.0%
l	1	10.0%
g	1	10.0%
s	1	10.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	10	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	2	20.0%
e	2	20.0%
r	1	10.0%
p	1	10.0%
v	1	10.0%
l	1	10.0%
g	1	10.0%
s	1	10.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	10	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	2	20.0%
e	2	20.0%
r	1	10.0%
p	1	10.0%
v	1	10.0%
l	1	10.0%
g	1	10.0%
s	1	10.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	10	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	2	20.0%
e	2	20.0%
r	1	10.0%
p	1	10.0%
v	1	10.0%
l	1	10.0%
g	1	10.0%
s	1	10.0%

Table: products

Profile: products

Overview

Brought to you by YData

Dataset statistics
Number of variables 15
Number of observations 45
Missing cells 65
Missing cells (%) 9.6%
Total size in memory 24.3 KiB
Average record size in memory 552.8 B

Variable types
Text 7
Numeric 7
Unsupported 1

Alerts

`discontinued` has constant value "0"	Constant
`attachments` has constant value ""	Constant
`__table_name__` has constant value "products"	Constant
`description` has 45 (100.0%) missing values	Missing
`quantity_per_unit` has 5 (11.1%) missing values	Missing
`minimum_reorder_quantity` has 15 (33.3%) missing values	Missing
`id` has unique values	Unique
`product_name` has unique values	Unique
`description` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`discontinued` has 45 (100.0%) zeros	Zeros

Reproduction
Analysis started 2025-10-30 16:47:35.634435
Analysis finished 2025-10-30 16:47:35.803163
Duration 0.17 seconds
Software version ydata-profiling vv4.17.0
Download configuration config.json

supplier_ids
Text

Distinct	12
Distinct (%)	26.7%
Missing	0
Missing (%)	0.0%
Memory size	2.7 KiB

Length
Max length 3
Median length 1
Mean length 1.333333333
Min length 1

Characters and Unicode
Total characters 60
Distinct characters 11
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 4 ?
Unique (%) 8.9%

Sample
1st row 6
2nd row 6
3rd row 6
4th row 6
5th row 6

Value	Count	Frequency (%)
6	11	24.4%
1	9	20.0%
10	5	11.1%
7	4	8.9%
2;6	4	8.9%
2	3	6.7%
8	3	6.7%
4	2	4.4%
9	1	2.2%
5	1	2.2%
Other values (2)	2	4.4%

Most occurring characters

Value	Count	Frequency (%)
6	15	25.0%
1	14	23.3%
2	7	11.7%
0	5	8.3%
;	5	8.3%
7	4	6.7%
8	3	5.0%
4	3	5.0%
3	2	3.3%
9	1	1.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	60	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
6	15	25.0%
1	14	23.3%
2	7	11.7%
0	5	8.3%
;	5	8.3%
7	4	6.7%
8	3	5.0%
4	3	5.0%
3	2	3.3%
9	1	1.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	60	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
6	15	25.0%
1	14	23.3%
2	7	11.7%
0	5	8.3%
;	5	8.3%
7	4	6.7%
8	3	5.0%
4	3	5.0%
3	2	3.3%
9	1	1.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	60	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
6	15	25.0%
1	14	23.3%
2	7	11.7%
0	5	8.3%
;	5	8.3%
7	4	6.7%
8	3	5.0%
4	3	5.0%
3	2	3.3%
9	1	1.7%

id
Real number (ℝ)

Unique

Distinct	45
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	57.93333333

Minimum	1
Maximum	99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	533.0 B

Quantile statistics
Minimum 1
5-th percentile 4.2
Q1 21
median 66
Q3 88
95-th percentile 96.8
Maximum 99
Range 98
Interquartile range (IQR) 67

Descriptive statistics
Standard deviation 33.75001684
Coefficient of variation (CV) 0.5825664586
Kurtosis -1.345925958
Mean 57.93333333
Median Absolute Deviation (MAD) 25
Skewness -0.4390602797
Sum 2607
Variance 1139.063636
Monotonicity Not monotonic

Histogram with fixed size bins (bins=45)

Value	Count	Frequency (%)
88	1	2.2%
89	1	2.2%
93	1	2.2%
94	1	2.2%
92	1	2.2%
91	1	2.2%
90	1	2.2%
82	1	2.2%
87	1	2.2%
96	1	2.2%
Other values (35)	35	77.8%

Value	Count	Frequency (%)
1	1	2.2%
3	1	2.2%
4	1	2.2%
5	1	2.2%
6	1	2.2%

Value	Count	Frequency (%)
99	1	2.2%
98	1	2.2%
97	1	2.2%
96	1	2.2%
95	1	2.2%

product_code
Text

Distinct	43
Distinct (%)	95.6%
Missing	0
Missing (%)	0.0%
Memory size	3.0 KiB

Length
Max length 9
Median length 8
Mean length 7.866666667
Min length 6

Characters and Unicode
Total characters 354
Distinct characters 26
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 41 ?
Unique (%) 91.1%

Sample
1st row NWTCFV-88
2nd row NWTCFV-89
3rd row NWTCFV-93
4th row NWTCFV-94
5th row NWTCFV-92

Value	Count	Frequency (%)
nwtc-82	2	4.4%
nwtjp-6	2	4.4%
nwtcfv-89	1	2.2%
nwtcfv-93	1	2.2%
nwtcfv-94	1	2.2%
nwtcfv-91	1	2.2%
nwtcfv-92	1	2.2%
nwtcfv-90	1	2.2%
nwtb-87	1	2.2%
nwtcm-96	1	2.2%
Other values (33)	33	73.3%

Most occurring characters

Value	Count	Frequency (%)
N	50	14.1%
W	45	12.7%
T	45	12.7%
-	45	12.7%
C	18	5.1%
8	14	4.0%
F	13	3.7%
9	12	3.4%
4	9	2.5%
1	9	2.5%
Other values (16)	94	26.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	354	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
N	50	14.1%
W	45	12.7%
T	45	12.7%
-	45	12.7%
C	18	5.1%
8	14	4.0%
F	13	3.7%
9	12	3.4%
4	9	2.5%
1	9	2.5%
Other values (16)	94	26.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	354	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
N	50	14.1%
W	45	12.7%
T	45	12.7%
-	45	12.7%
C	18	5.1%
8	14	4.0%
F	13	3.7%
9	12	3.4%
4	9	2.5%
1	9	2.5%
Other values (16)	94	26.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	354	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
N	50	14.1%
W	45	12.7%
T	45	12.7%
-	45	12.7%
C	18	5.1%
8	14	4.0%
F	13	3.7%
9	12	3.4%
4	9	2.5%
1	9	2.5%
Other values (16)	94	26.6%

product_name
Text

Unique

Distinct	45
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	3.9 KiB

Length
Max length 40
Median length 33
Mean length 27.8
Min length 21

Characters and Unicode
Total characters 1251
Distinct characters 43
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 45 ?
Unique (%) 100.0%

Sample
1st row Northwind Traders Pears
2nd row Northwind Traders Peaches
3rd row Northwind Traders Corn
4th row Northwind Traders Peas
5th row Northwind Traders Green Beans

Value	Count	Frequency (%)
northwind	45	27.4%
traders	45	27.4%
mix	3	1.8%
dried	3	1.8%
sauce	3	1.8%
chocolate	2	1.2%
tea	2	1.2%
pears	2	1.2%
hot	2	1.2%
green	2	1.2%
Other values (54)	55	33.5%

Most occurring characters

Value	Count	Frequency (%)
r	163	13.0%
	119	9.5%
d	99	7.9%
e	96	7.7%
a	84	6.7%
o	73	5.8%
i	72	5.8%
n	66	5.3%
s	62	5.0%
t	59	4.7%
Other values (33)	358	28.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1251	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	163	13.0%
	119	9.5%
d	99	7.9%
e	96	7.7%
a	84	6.7%
o	73	5.8%
i	72	5.8%
n	66	5.3%
s	62	5.0%
t	59	4.7%
Other values (33)	358	28.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1251	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	163	13.0%
	119	9.5%
d	99	7.9%
e	96	7.7%
a	84	6.7%
o	73	5.8%
i	72	5.8%
n	66	5.3%
s	62	5.0%
t	59	4.7%
Other values (33)	358	28.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1251	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	163	13.0%
	119	9.5%
d	99	7.9%
e	96	7.7%
a	84	6.7%
o	73	5.8%
i	72	5.8%
n	66	5.3%
s	62	5.0%
t	59	4.7%
Other values (33)	358	28.6%

description
Unsupported

Missing Rejected Unsupported

Missing	45
Missing (%)	100.0%
Memory size	488.0 B

standard_cost
Real number (ℝ)

Distinct	29
Distinct (%)	64.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.6825

Minimum	0.5
Maximum	60.75
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	488.0 B

Quantile statistics
Minimum 0.5
5-th percentile 1
Q1 2
median 7.5
Q3 16.0125
95-th percentile 33.6
Maximum 60.75
Range 60.25
Interquartile range (IQR) 14.0125

Descriptive statistics
Standard deviation 12.68946089
Coefficient of variation (CV) 1.086193956
Kurtosis 4.054435737
Mean 11.6825
Median Absolute Deviation (MAD) 6.5
Skewness 1.794124107
Sum 525.7125
Variance 161.0224176
Monotonicity Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
1	9	20.0%
2	4	8.9%
7.5	3	6.7%
3	2	4.4%
0.5	2	4.4%
10.5	2	4.4%
6.9	1	2.2%
9	1	2.2%
16.0125	1	2.2%
29.25	1	2.2%
Other values (19)	19	42.2%

Value	Count	Frequency (%)
0.5	2	4.4%
1	9	20.0%
2	4	8.9%
3	2	4.4%
5.25	1	2.2%

Value	Count	Frequency (%)
60.75	1	2.2%
39.75	1	2.2%
34.5	1	2.2%
30	1	2.2%
29.25	1	2.2%

list_price
Real number (ℝ)

Distinct	37
Distinct (%)	82.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.84577778

Minimum	1.2
Maximum	81
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	488.0 B

Quantile statistics
Minimum 1.2
5-th percentile 1.34
Q1 2.99
median 10
Q3 21.35
95-th percentile 44.8
Maximum 81
Range 79.8
Interquartile range (IQR) 18.36

Descriptive statistics
Standard deviation 16.74302236
Coefficient of variation (CV) 1.056623575
Kurtosis 4.20573241
Mean 15.84577778
Median Absolute Deviation (MAD) 8.11
Skewness 1.8263175
Sum 713.06
Variance 280.3287977
Monotonicity Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
4	3	6.7%
10	3	6.7%
1.2	2	4.4%
2	2	4.4%
1.5	2	4.4%
1.8	2	4.4%
1.3	1	2.2%
1.89	1	2.2%
5	1	2.2%
1.95	1	2.2%
Other values (27)	27	60.0%

Value	Count	Frequency (%)
1.2	2	4.4%
1.3	1	2.2%
1.5	2	4.4%
1.8	2	4.4%
1.89	1	2.2%

Value	Count	Frequency (%)
81	1	2.2%
53	1	2.2%
46	1	2.2%
40	1	2.2%
39	1	2.2%

reorder_level
Real number (ℝ)

Distinct	8
Distinct (%)	17.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.44444444

Minimum	5
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	533.0 B

Quantile statistics
Minimum 5
5-th percentile 6
Q1 10
median 10
Q3 25
95-th percentile 90
Maximum 100
Range 95
Interquartile range (IQR) 15

Descriptive statistics
Standard deviation 23.44292446
Coefficient of variation (CV) 1.044486733
Kurtosis 6.313945684
Mean 22.44444444
Median Absolute Deviation (MAD) 5
Skewness 2.559187705
Sum 1010
Variance 549.5707071
Monotonicity Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
10	21	46.7%
30	5	11.1%
25	5	11.1%
20	4	8.9%
5	3	6.7%
100	3	6.7%
50	2	4.4%
15	2	4.4%

Value	Count	Frequency (%)
5	3	6.7%
10	21	46.7%
15	2	4.4%
20	4	8.9%
25	5	11.1%

Value	Count	Frequency (%)
100	3	6.7%
50	2	4.4%
30	5	11.1%
25	5	11.1%
20	4	8.9%

target_level
Real number (ℝ)

Distinct	10
Distinct (%)	22.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	69.55555556

Minimum	20
Maximum	200
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	533.0 B

Quantile statistics
Minimum 20
5-th percentile 20
Q1 40
median 40
Q3 100
95-th percentile 200
Maximum 200
Range 180
Interquartile range (IQR) 60

Descriptive statistics
Standard deviation 50.50677522
Coefficient of variation (CV) 0.726135746
Kurtosis 1.711244811
Mean 69.55555556
Median Absolute Deviation (MAD) 20
Skewness 1.542215931
Sum 3130
Variance 2550.934343
Monotonicity Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
40	19	42.2%
100	6	13.3%
20	5	11.1%
200	4	8.9%
50	3	6.7%
60	2	4.4%
80	2	4.4%
120	2	4.4%
75	1	2.2%
125	1	2.2%

Value	Count	Frequency (%)
20	5	11.1%
40	19	42.2%
50	3	6.7%
60	2	4.4%
75	1	2.2%

Value	Count	Frequency (%)
200	4	8.9%
125	1	2.2%
120	2	4.4%
100	6	13.3%
80	2	4.4%

quantity_per_unit
Text

Missing

Distinct	32
Distinct (%)	80.0%
Missing	5
Missing (%)	11.1%
Memory size	3.0 KiB

Length
Max length 20
Median length 17.5
Mean length 12.25
Min length 4

Characters and Unicode
Total characters 490
Distinct characters 33
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 28 ?
Unique (%) 70.0%

Sample
1st row 15.25 OZ
2nd row 15.25 OZ
3rd row 14.5 OZ
4th row 14.5 OZ
5th row 14.5 OZ

Value	Count	Frequency (%)
oz	18	12.2%
	17	11.6%
12	10	6.8%
pkgs	8	5.4%
boxes	8	5.4%
24	7	4.8%
g	6	4.1%
15.25	5	3.4%
jars	4	2.7%
14.5	3	2.0%
Other values (37)	61	41.5%

Most occurring characters

Value	Count	Frequency (%)
	107	21.8%
s	30	6.1%
2	29	5.9%
1	27	5.5%
o	24	4.9%
5	22	4.5%
g	21	4.3%
0	21	4.3%
b	18	3.7%
-	17	3.5%
Other values (23)	174	35.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	490	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	107	21.8%
s	30	6.1%
2	29	5.9%
1	27	5.5%
o	24	4.9%
5	22	4.5%
g	21	4.3%
0	21	4.3%
b	18	3.7%
-	17	3.5%
Other values (23)	174	35.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	490	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	107	21.8%
s	30	6.1%
2	29	5.9%
1	27	5.5%
o	24	4.9%
5	22	4.5%
g	21	4.3%
0	21	4.3%
b	18	3.7%
-	17	3.5%
Other values (23)	174	35.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	490	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	107	21.8%
s	30	6.1%
2	29	5.9%
1	27	5.5%
o	24	4.9%
5	22	4.5%
g	21	4.3%
0	21	4.3%
b	18	3.7%
-	17	3.5%
Other values (23)	174	35.5%

discontinued
Real number (ℝ)

Constant Zeros

Distinct	1
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0

Minimum	0
Maximum	0
Zeros	45
Zeros (%)	100.0%
Negative	0
Negative (%)	0.0%
Memory size	533.0 B

Quantile statistics
Minimum 0
5-th percentile 0
Q1 0
median 0
Q3 0
95-th percentile 0
Maximum 0
Range 0
Interquartile range (IQR) 0

Descriptive statistics
Standard deviation 0
Coefficient of variation (CV) nan
Kurtosis 0
Mean 0
Median Absolute Deviation (MAD) 0
Skewness 0
Sum 0
Variance 0
Monotonicity Increasing

Histogram with fixed size bins (bins=1)

Value	Count	Frequency (%)
0	45	100.0%

Value	Count	Frequency (%)
0	45	100.0%

Value	Count	Frequency (%)
0	45	100.0%

minimum_reorder_quantity
Real number (ℝ)

Missing

Distinct	6
Distinct (%)	20.0%
Missing	15
Missing (%)	33.3%
Infinite	0
Infinite (%)	0.0%
Mean	15

Minimum	5
Maximum	30
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	533.0 B

Quantile statistics
Minimum 5
5-th percentile 5
Q1 10
median 10
Q3 25
95-th percentile 27.75
Maximum 30
Range 25
Interquartile range (IQR) 15

Descriptive statistics
Standard deviation 8.304547985
Coefficient of variation (CV) 0.5536365324
Kurtosis -1.286011905
Mean 15
Median Absolute Deviation (MAD) 5
Skewness 0.4838140679
Sum 450
Variance 68.96551724
Monotonicity Increasing

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
10	12	26.7%
25	7	15.6%
5	5	11.1%
15	2	4.4%
20	2	4.4%
30	2	4.4%
(Missing)	15	33.3%

Value	Count	Frequency (%)
5	5	11.1%
10	12	26.7%
15	2	4.4%
20	2	4.4%
25	7	15.6%

Value	Count	Frequency (%)
30	2	4.4%
25	7	15.6%
20	2	4.4%
15	2	4.4%
10	12	26.7%

category
Text

Distinct	16
Distinct (%)	35.6%
Missing	0
Missing (%)	0.0%
Memory size	3.2 KiB

Length
Max length 31
Median length 18
Mean length 13.71111111
Min length 3

Characters and Unicode
Total characters 617
Distinct characters 40
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 5 ?
Unique (%) 11.1%

Sample
1st row Canned Fruit & Vegetables
2nd row Canned Fruit & Vegetables
3rd row Canned Fruit & Vegetables
4th row Canned Fruit & Vegetables
5th row Canned Fruit & Vegetables

Value	Count	Frequency (%)
	17	16.5%
fruit	13	12.6%
canned	11	10.7%
vegetables	8	7.8%
beverages	5	4.9%
dried	5	4.9%
nuts	5	4.9%
baked	4	3.9%
goods	4	3.9%
mixes	4	3.9%
Other values (15)	27	26.2%

Most occurring characters

Value	Count	Frequency (%)
e	82	13.3%
	58	9.4%
s	47	7.6%
a	46	7.5%
t	36	5.8%
n	33	5.3%
r	33	5.3%
d	31	5.0%
i	30	4.9%
u	25	4.1%
Other values (30)	196	31.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	617	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	82	13.3%
	58	9.4%
s	47	7.6%
a	46	7.5%
t	36	5.8%
n	33	5.3%
r	33	5.3%
d	31	5.0%
i	30	4.9%
u	25	4.1%
Other values (30)	196	31.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	617	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	82	13.3%
	58	9.4%
s	47	7.6%
a	46	7.5%
t	36	5.8%
n	33	5.3%
r	33	5.3%
d	31	5.0%
i	30	4.9%
u	25	4.1%
Other values (30)	196	31.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	617	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	82	13.3%
	58	9.4%
s	47	7.6%
a	46	7.5%
t	36	5.8%
n	33	5.3%
r	33	5.3%
d	31	5.0%
i	30	4.9%
u	25	4.1%
Other values (30)	196	31.8%

attachments
Text

Constant

Distinct	1
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Memory size	2.6 KiB

Length
Max length 0
Median length 0
Mean length 0
Min length 0

Characters and Unicode
Total characters 0
Distinct characters 0
Distinct categories 0 ?
Distinct scripts 0 ?
Distinct blocks 0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row
2nd row
3rd row
4th row
5th row

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

__table_name__
Text

Constant

Distinct	1
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Memory size	3.0 KiB

Length
Max length 8
Median length 8
Mean length 8
Min length 8

Characters and Unicode
Total characters 360
Distinct characters 8
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row products
2nd row products
3rd row products
4th row products
5th row products

Value	Count	Frequency (%)
products	45	100.0%

Most occurring characters

Value	Count	Frequency (%)
p	45	12.5%
r	45	12.5%
o	45	12.5%
d	45	12.5%
u	45	12.5%
c	45	12.5%
t	45	12.5%
s	45	12.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	360	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
p	45	12.5%
r	45	12.5%
o	45	12.5%
d	45	12.5%
u	45	12.5%
c	45	12.5%
t	45	12.5%
s	45	12.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	360	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
p	45	12.5%
r	45	12.5%
o	45	12.5%
d	45	12.5%
u	45	12.5%
c	45	12.5%
t	45	12.5%
s	45	12.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	360	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
p	45	12.5%
r	45	12.5%
o	45	12.5%
d	45	12.5%
u	45	12.5%
c	45	12.5%
t	45	12.5%
s	45	12.5%

Table: purchase_order_details

Profile: purchase_order_details

Overview

Brought to you by YData

Dataset statistics
Number of variables 9
Number of observations 55
Missing cells 24
Missing cells (%) 4.8%
Total size in memory 8.1 KiB
Average record size in memory 150.3 B

Variable types
Numeric 7
DateTime 1
Text 1

Alerts

`__table_name__` has constant value "purchase_order_details"	Constant
`date_received` has 12 (21.8%) missing values	Missing
`inventory_id` has 12 (21.8%) missing values	Missing
`id` has unique values	Unique
`posted_to_inventory` has 12 (21.8%) zeros	Zeros

Reproduction
Analysis started 2025-10-30 16:47:41.317092
Analysis finished 2025-10-30 16:47:41.402079
Duration 0.08 seconds
Software version ydata-profiling vv4.17.0
Download configuration config.json

id
Real number (ℝ)

Unique

Distinct	55
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	265.3636364

Minimum	238
Maximum	295
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	623.0 B

Quantile statistics
Minimum 238
5-th percentile 240.7
Q1 251.5
median 265
Q3 278.5
95-th percentile 292.3
Maximum 295
Range 57
Interquartile range (IQR) 27

Descriptive statistics
Standard deviation 16.58687973
Coefficient of variation (CV) 0.06250622714
Kurtosis -1.109720524
Mean 265.3636364
Median Absolute Deviation (MAD) 14
Skewness 0.09284713327
Sum 14595
Variance 275.1245791
Monotonicity Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
238	1	1.8%
241	1	1.8%
240	1	1.8%
243	1	1.8%
244	1	1.8%
239	1	1.8%
242	1	1.8%
290	1	1.8%
288	1	1.8%
289	1	1.8%
Other values (45)	45	81.8%

Value	Count	Frequency (%)
238	1	1.8%
239	1	1.8%
240	1	1.8%
241	1	1.8%
242	1	1.8%

Value	Count	Frequency (%)
295	1	1.8%
294	1	1.8%
293	1	1.8%
292	1	1.8%
290	1	1.8%

purchase_order_id
Real number (ℝ)

Distinct	28
Distinct (%)	50.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	101.8363636

Minimum	90
Maximum	148
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	623.0 B

Quantile statistics
Minimum 90
5-th percentile 90
Q1 92
median 93
Q3 104.5
95-th percentile 146
Maximum 148
Range 58
Interquartile range (IQR) 12.5

Descriptive statistics
Standard deviation 17.41408927
Coefficient of variation (CV) 0.171000698
Kurtosis 2.17396244
Mean 101.8363636
Median Absolute Deviation (MAD) 3
Skewness 1.858271259
Sum 5601
Variance 303.2505051
Monotonicity Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
92	15	27.3%
91	7	12.7%
90	5	9.1%
93	3	5.5%
146	2	3.6%
142	1	1.8%
103	1	1.8%
140	1	1.8%
108	1	1.8%
109	1	1.8%
Other values (18)	18	32.7%

Value	Count	Frequency (%)
90	5	9.1%
91	7	12.7%
92	15	27.3%
93	3	5.5%
94	1	1.8%

Value	Count	Frequency (%)
148	1	1.8%
147	1	1.8%
146	2	3.6%
142	1	1.8%
141	1	1.8%

product_id
Real number (ℝ)

Distinct	29
Distinct (%)	52.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.36363636

Minimum	1
Maximum	85
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	623.0 B

Quantile statistics
Minimum 1
5-th percentile 2.4
Q1 15.5
median 40
Q3 54
95-th percentile 80.3
Maximum 85
Range 84
Interquartile range (IQR) 38.5

Descriptive statistics
Standard deviation 25.75767677
Coefficient of variation (CV) 0.7083361111
Kurtosis -1.10546677
Mean 36.36363636
Median Absolute Deviation (MAD) 21
Skewness 0.2609547134
Sum 2000
Variance 663.4579125
Monotonicity Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
19	5	9.1%
43	4	7.3%
34	4	7.3%
72	3	5.5%
1	3	5.5%
41	3	5.5%
51	2	3.6%
6	2	3.6%
48	2	3.6%
20	2	3.6%
Other values (19)	25	45.5%

Value	Count	Frequency (%)
1	3	5.5%
3	2	3.6%
4	2	3.6%
5	1	1.8%
6	2	3.6%

Value	Count	Frequency (%)
85	1	1.8%
81	2	3.6%
80	1	1.8%
77	1	1.8%
74	1	1.8%

quantity
Real number (ℝ)

Distinct	16
Distinct (%)	29.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	77.47272727

Minimum	1
Maximum	300
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	568.0 B

Quantile statistics
Minimum 1
5-th percentile 10
Q1 40
median 40
Q3 100
95-th percentile 265
Maximum 300
Range 299
Interquartile range (IQR) 60

Descriptive statistics
Standard deviation 73.04104745
Coefficient of variation (CV) 0.9427969044
Kurtosis 3.301769212
Mean 77.47272727
Median Absolute Deviation (MAD) 20
Skewness 1.912953888
Sum 4261
Variance 5334.994613
Monotonicity Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
40	17	30.9%
100	8	14.5%
50	4	7.3%
20	4	7.3%
10	3	5.5%
120	3	5.5%
300	3	5.5%
25	2	3.6%
200	2	3.6%
60	2	3.6%
Other values (6)	7	12.7%

Value	Count	Frequency (%)
1	1	1.8%
10	3	5.5%
20	4	7.3%
25	2	3.6%
30	1	1.8%

Value	Count	Frequency (%)
300	3	5.5%
250	1	1.8%
200	2	3.6%
125	1	1.8%
120	3	5.5%

unit_cost
Real number (ℝ)

Distinct	25
Distinct (%)	45.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.49545455

Minimum	2
Maximum	61
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	568.0 B

Quantile statistics
Minimum 2
5-th percentile 4.4
Q1 8
median 14
Q3 26
95-th percentile 39.3
Maximum 61
Range 59
Interquartile range (IQR) 18

Descriptive statistics
Standard deviation 13.06877206
Coefficient of variation (CV) 0.7469809956
Kurtosis 2.537306376
Mean 17.49545455
Median Absolute Deviation (MAD) 7
Skewness 1.53165381
Sum 962.25
Variance 170.792803
Monotonicity Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
7	8	14.5%
10	7	12.7%
34	4	7.3%
8	4	7.3%
16	4	7.3%
26	3	5.5%
14	3	5.5%
30	2	3.6%
15	2	3.6%
2	2	3.6%
Other values (15)	16	29.1%

Value	Count	Frequency (%)
2	2	3.6%
3	1	1.8%
5	1	1.8%
7	8	14.5%
8	4	7.3%

Value	Count	Frequency (%)
61	1	1.8%
60	1	1.8%
40	1	1.8%
39	1	1.8%
34	4	7.3%

date_received
Date

Missing

Distinct	6
Distinct (%)	14.0%
Missing	12
Missing (%)	21.8%
Memory size	568.0 B

Minimum	2006-01-22 00:00:00
Maximum	2006-04-17 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=6)

posted_to_inventory
Real number (ℝ)

Zeros

Distinct	2
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.7818181818

Minimum	0
Maximum	1
Zeros	12
Zeros (%)	21.8%
Negative	0
Negative (%)	0.0%
Memory size	623.0 B

Quantile statistics
Minimum 0
5-th percentile 0
Q1 1
median 1
Q3 1
95-th percentile 1
Maximum 1
Range 1
Interquartile range (IQR) 0

Descriptive statistics
Standard deviation 0.4168181543
Coefficient of variation (CV) 0.5331394997
Kurtosis -0.03341546562
Mean 0.7818181818
Median Absolute Deviation (MAD) 0
Skewness -1.4032634
Sum 43
Variance 0.1737373737
Monotonicity Not monotonic

Histogram with fixed size bins (bins=2)

Value	Count	Frequency (%)
1	43	78.2%
0	12	21.8%

Value	Count	Frequency (%)
0	12	21.8%
1	43	78.2%

Value	Count	Frequency (%)
1	43	78.2%
0	12	21.8%

inventory_id
Real number (ℝ)

Missing

Distinct	43
Distinct (%)	100.0%
Missing	12
Missing (%)	21.8%
Infinite	0
Infinite (%)	0.0%
Mean	64.76744186

Minimum	35
Maximum	115
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	623.0 B

Quantile statistics
Minimum 35
5-th percentile 37.1
Q1 45.5
median 56
Q3 79
95-th percentile 110.8
Maximum 115
Range 80
Interquartile range (IQR) 33.5

Descriptive statistics
Standard deviation 25.18487567
Coefficient of variation (CV) 0.3888508631
Kurtosis -0.7107985776
Mean 64.76744186
Median Absolute Deviation (MAD) 15
Skewness 0.8126450747
Sum 2785
Variance 634.2779623
Monotonicity Not monotonic

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
59	1	1.8%
55	1	1.8%
56	1	1.8%
42	1	1.8%
54	1	1.8%
40	1	1.8%
111	1	1.8%
45	1	1.8%
47	1	1.8%
52	1	1.8%
Other values (33)	33	60.0%
(Missing)	12	21.8%

Value	Count	Frequency (%)
35	1	1.8%
36	1	1.8%
37	1	1.8%
38	1	1.8%
39	1	1.8%

Value	Count	Frequency (%)
115	1	1.8%
113	1	1.8%
111	1	1.8%
109	1	1.8%
107	1	1.8%

__table_name__
Text

Constant

Distinct	1
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	4.4 KiB

Length
Max length 22
Median length 22
Mean length 22
Min length 22

Characters and Unicode
Total characters 1210
Distinct characters 14
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row purchase_order_details
2nd row purchase_order_details
3rd row purchase_order_details
4th row purchase_order_details
5th row purchase_order_details

Value	Count	Frequency (%)
purchase_order_details	55	100.0%

Most occurring characters

Value	Count	Frequency (%)
r	165	13.6%
e	165	13.6%
d	110	9.1%
_	110	9.1%
s	110	9.1%
a	110	9.1%
h	55	4.5%
c	55	4.5%
p	55	4.5%
u	55	4.5%
Other values (4)	220	18.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1210	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	165	13.6%
e	165	13.6%
d	110	9.1%
_	110	9.1%
s	110	9.1%
a	110	9.1%
h	55	4.5%
c	55	4.5%
p	55	4.5%
u	55	4.5%
Other values (4)	220	18.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1210	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	165	13.6%
e	165	13.6%
d	110	9.1%
_	110	9.1%
s	110	9.1%
a	110	9.1%
h	55	4.5%
c	55	4.5%
p	55	4.5%
u	55	4.5%
Other values (4)	220	18.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1210	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	165	13.6%
e	165	13.6%
d	110	9.1%
_	110	9.1%
s	110	9.1%
a	110	9.1%
h	55	4.5%
c	55	4.5%
p	55	4.5%
u	55	4.5%
Other values (4)	220	18.2%

Table: purchase_order_status

Profile: purchase_order_status

Overview

Brought to you by YData

Dataset statistics
Number of variables 3
Number of observations 4
Missing cells 0
Missing cells (%) 0.0%
Total size in memory 730.0 B
Average record size in memory 182.5 B

Variable types
Numeric 1
Text 2

Alerts

`__table_name__` has constant value "purchase_order_status"	Constant
`id` has unique values	Unique
`status` has unique values	Unique
`id` has 1 (25.0%) zeros	Zeros

Reproduction
Analysis started 2025-10-30 16:47:46.377800
Analysis finished 2025-10-30 16:47:46.418535
Duration 0.04 seconds
Software version ydata-profiling vv4.17.0
Download configuration config.json

id
Real number (ℝ)

Unique Zeros

Distinct	4
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.5

Minimum	0
Maximum	3
Zeros	1
Zeros (%)	25.0%
Negative	0
Negative (%)	0.0%
Memory size	164.0 B

Quantile statistics
Minimum 0
5-th percentile 0.15
Q1 0.75
median 1.5
Q3 2.25
95-th percentile 2.85
Maximum 3
Range 3
Interquartile range (IQR) 1.5

Histogram with fixed size bins (bins=4)

Value	Count	Frequency (%)
0	1	25.0%
1	1	25.0%
2	1	25.0%
3	1	25.0%

Value	Count	Frequency (%)
0	1	25.0%
1	1	25.0%
2	1	25.0%
3	1	25.0%

Value	Count	Frequency (%)
3	1	25.0%
2	1	25.0%
1	1	25.0%
0	1	25.0%

status
Text

Unique

Distinct	4
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	382.0 B

Length
Max length 9
Median length 7
Mean length 6.5
Min length 3

Characters and Unicode
Total characters 26
Distinct characters 18
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 4 ?
Unique (%) 100.0%

Sample
1st row New
2nd row Submitted
3rd row Approved
4th row Closed

Value	Count	Frequency (%)
new	1	25.0%
submitted	1	25.0%
approved	1	25.0%
closed	1	25.0%

Most occurring characters

Value	Count	Frequency (%)
e	4	15.4%
d	3	11.5%
o	2	7.7%
t	2	7.7%
p	2	7.7%
N	1	3.8%
b	1	3.8%
u	1	3.8%
w	1	3.8%
S	1	3.8%
Other values (8)	8	30.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	26	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	4	15.4%
d	3	11.5%
o	2	7.7%
t	2	7.7%
p	2	7.7%
N	1	3.8%
b	1	3.8%
u	1	3.8%
w	1	3.8%
S	1	3.8%
Other values (8)	8	30.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	26	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	4	15.4%
d	3	11.5%
o	2	7.7%
t	2	7.7%
p	2	7.7%
N	1	3.8%
b	1	3.8%
u	1	3.8%
w	1	3.8%
S	1	3.8%
Other values (8)	8	30.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	26	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	4	15.4%
d	3	11.5%
o	2	7.7%
t	2	7.7%
p	2	7.7%
N	1	3.8%
b	1	3.8%
u	1	3.8%
w	1	3.8%
S	1	3.8%
Other values (8)	8	30.8%

__table_name__
Text

Constant

Distinct	1
Distinct (%)	25.0%
Missing	0
Missing (%)	0.0%
Memory size	440.0 B

Length
Max length 21
Median length 21
Mean length 21
Min length 21

Characters and Unicode
Total characters 84
Distinct characters 12
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row purchase_order_status
2nd row purchase_order_status
3rd row purchase_order_status
4th row purchase_order_status

Value	Count	Frequency (%)
purchase_order_status	4	100.0%

Most occurring characters

Value	Count	Frequency (%)
r	12	14.3%
s	12	14.3%
a	8	9.5%
u	8	9.5%
t	8	9.5%
_	8	9.5%
e	8	9.5%
p	4	4.8%
c	4	4.8%
h	4	4.8%
Other values (2)	8	9.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	84	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	12	14.3%
s	12	14.3%
a	8	9.5%
u	8	9.5%
t	8	9.5%
_	8	9.5%
e	8	9.5%
p	4	4.8%
c	4	4.8%
h	4	4.8%
Other values (2)	8	9.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	84	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	12	14.3%
s	12	14.3%
a	8	9.5%
u	8	9.5%
t	8	9.5%
_	8	9.5%
e	8	9.5%
p	4	4.8%
c	4	4.8%
h	4	4.8%
Other values (2)	8	9.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	84	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	12	14.3%
s	12	14.3%
a	8	9.5%
u	8	9.5%
t	8	9.5%
_	8	9.5%
e	8	9.5%
p	4	4.8%
c	4	4.8%
h	4	4.8%
Other values (2)	8	9.5%

Table: purchase_orders

Profile: purchase_orders

Overview

Brought to you by YData

Dataset statistics
Number of variables 17
Number of observations 28
Missing cells 103
Missing cells (%) 21.6%
Total size in memory 7.8 KiB
Average record size in memory 285.3 B

Variable types
Numeric 9
DateTime 3
Unsupported 2
Text 3

Alerts

`shipping_fee` has constant value "0.0"	Constant
`taxes` has constant value "0.0"	Constant
`payment_amount` has constant value "0.0"	Constant
`payment_method` has constant value "Check"	Constant
`approved_by` has constant value "2"	Constant
`__table_name__` has constant value "purchase_orders"	Constant
`created_by` has 3 (10.7%) missing values	Missing
`expected_date` has 28 (100.0%) missing values	Missing
`payment_date` has 28 (100.0%) missing values	Missing
`payment_method` has 26 (92.9%) missing values	Missing
`notes` has 12 (42.9%) missing values	Missing
`approved_by` has 3 (10.7%) missing values	Missing
`approved_date` has 3 (10.7%) missing values	Missing
`id` has unique values	Unique
`expected_date` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`payment_date` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`shipping_fee` has 28 (100.0%) zeros	Zeros
`taxes` has 28 (100.0%) zeros	Zeros
`payment_amount` has 28 (100.0%) zeros	Zeros

Reproduction
Analysis started 2025-10-30 16:47:48.236516
Analysis finished 2025-10-30 16:47:48.366463
Duration 0.13 seconds
Software version ydata-profiling vv4.17.0
Download configuration config.json

id
Real number (ℝ)

Unique

Distinct	28
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	109.8214286

Minimum	90
Maximum	148
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	380.0 B

Quantile statistics
Minimum 90
5-th percentile 91.35
Q1 96.75
median 103.5
Q3 110.25
95-th percentile 146.65
Maximum 148
Range 58
Interquartile range (IQR) 13.5

Descriptive statistics
Standard deviation 19.11379872
Coefficient of variation (CV) 0.1740443461
Kurtosis -0.1453706217
Mean 109.8214286
Median Absolute Deviation (MAD) 7
Skewness 1.159088306
Sum 3075
Variance 365.3373016
Monotonicity Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
90	1	3.6%
93	1	3.6%
95	1	3.6%
91	1	3.6%
92	1	3.6%
94	1	3.6%
96	1	3.6%
97	1	3.6%
98	1	3.6%
99	1	3.6%
Other values (18)	18	64.3%

Value	Count	Frequency (%)
90	1	3.6%
91	1	3.6%
92	1	3.6%
93	1	3.6%
94	1	3.6%

Value	Count	Frequency (%)
148	1	3.6%
147	1	3.6%
146	1	3.6%
142	1	3.6%
141	1	3.6%

supplier_id
Real number (ℝ)

Distinct	8
Distinct (%)	28.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.178571429

Minimum	1
Maximum	8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	380.0 B

Quantile statistics
Minimum 1
5-th percentile 1
Q1 1
median 2
Q3 5
95-th percentile 7.65
Maximum 8
Range 7
Interquartile range (IQR) 4

Descriptive statistics
Standard deviation 2.326236373
Coefficient of variation (CV) 0.7318496453
Kurtosis -0.6545868539
Mean 3.178571429
Median Absolute Deviation (MAD) 1
Skewness 0.8509716215
Sum 89
Variance 5.411375661
Monotonicity Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
2	9	32.1%
1	8	28.6%
6	3	10.7%
5	3	10.7%
8	2	7.1%
4	1	3.6%
3	1	3.6%
7	1	3.6%

Value	Count	Frequency (%)
1	8	28.6%
2	9	32.1%
3	1	3.6%
4	1	3.6%
5	3	10.7%

Value	Count	Frequency (%)
8	2	7.1%
7	1	3.6%
6	3	10.7%
5	3	10.7%
4	1	3.6%

created_by
Real number (ℝ)

Missing

Distinct	8
Distinct (%)	32.0%
Missing	3
Missing (%)	10.7%
Infinite	0
Infinite (%)	0.0%
Mean	3.36

Minimum	1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	380.0 B

Quantile statistics
Minimum 1
5-th percentile 1
Q1 2
median 2
Q3 4
95-th percentile 7
Maximum 9
Range 8
Interquartile range (IQR) 2

Descriptive statistics
Standard deviation 2.23383079
Coefficient of variation (CV) 0.6648305924
Kurtosis 0.2941509212
Mean 3.36
Median Absolute Deviation (MAD) 1
Skewness 1.13965088
Sum 84
Variance 4.99
Monotonicity Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
2	11	39.3%
7	3	10.7%
4	3	10.7%
1	3	10.7%
3	2	7.1%
5	1	3.6%
9	1	3.6%
6	1	3.6%
(Missing)	3	10.7%

Value	Count	Frequency (%)
1	3	10.7%
2	11	39.3%
3	2	7.1%
4	3	10.7%
5	1	3.6%

Value	Count	Frequency (%)
9	1	3.6%
7	3	10.7%
6	1	3.6%
5	1	3.6%
4	3	10.7%

submitted_date
Date

Distinct	7
Distinct (%)	25.0%
Missing	0
Missing (%)	0.0%
Memory size	352.0 B

Minimum	2006-01-14 00:00:00
Maximum	2006-04-26 18:33:52
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=7)

creation_date
Date

Distinct	9
Distinct (%)	32.1%
Missing	0
Missing (%)	0.0%
Memory size	352.0 B

Minimum	2006-01-22 00:00:00
Maximum	2006-04-26 18:33:52
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=9)

status_id
Real number (ℝ)

Distinct	2
Distinct (%)	7.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.892857143

Minimum	1
Maximum	2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	380.0 B

Quantile statistics
Minimum 1
5-th percentile 1
Q1 2
median 2
Q3 2
95-th percentile 2
Maximum 2
Range 1
Interquartile range (IQR) 0

Descriptive statistics
Standard deviation 0.3149703942
Coefficient of variation (CV) 0.1663994535
Kurtosis 5.613784615
Mean 1.892857143
Median Absolute Deviation (MAD) 0
Skewness -2.686455177
Sum 53
Variance 0.09920634921
Monotonicity Decreasing

Histogram with fixed size bins (bins=2)

Value	Count	Frequency (%)
2	25	89.3%
1	3	10.7%

Value	Count	Frequency (%)
1	3	10.7%
2	25	89.3%

Value	Count	Frequency (%)
2	25	89.3%
1	3	10.7%

expected_date
Unsupported

Missing Rejected Unsupported

Missing	28
Missing (%)	100.0%
Memory size	352.0 B

shipping_fee
Real number (ℝ)

Constant Zeros

Distinct	1
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0

Minimum	0
Maximum	0
Zeros	28
Zeros (%)	100.0%
Negative	0
Negative (%)	0.0%
Memory size	352.0 B

Quantile statistics
Minimum 0
5-th percentile 0
Q1 0
median 0
Q3 0
95-th percentile 0
Maximum 0
Range 0
Interquartile range (IQR) 0

Descriptive statistics
Standard deviation 0
Coefficient of variation (CV) nan
Kurtosis 0
Mean 0
Median Absolute Deviation (MAD) 0
Skewness 0
Sum 0
Variance 0
Monotonicity Increasing

Histogram with fixed size bins (bins=1)

Value	Count	Frequency (%)
0	28	100.0%

Value	Count	Frequency (%)
0	28	100.0%

Value	Count	Frequency (%)
0	28	100.0%

taxes
Real number (ℝ)

Constant Zeros

Distinct	1
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0

Minimum	0
Maximum	0
Zeros	28
Zeros (%)	100.0%
Negative	0
Negative (%)	0.0%
Memory size	352.0 B

Quantile statistics
Minimum 0
5-th percentile 0
Q1 0
median 0
Q3 0
95-th percentile 0
Maximum 0
Range 0
Interquartile range (IQR) 0

Descriptive statistics
Standard deviation 0
Coefficient of variation (CV) nan
Kurtosis 0
Mean 0
Median Absolute Deviation (MAD) 0
Skewness 0
Sum 0
Variance 0
Monotonicity Increasing

Histogram with fixed size bins (bins=1)

Value	Count	Frequency (%)
0	28	100.0%

Value	Count	Frequency (%)
0	28	100.0%

Value	Count	Frequency (%)
0	28	100.0%

payment_date
Unsupported

Missing Rejected Unsupported

Missing	28
Missing (%)	100.0%
Memory size	352.0 B

payment_amount
Real number (ℝ)

Constant Zeros

Distinct	1
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0

Minimum	0
Maximum	0
Zeros	28
Zeros (%)	100.0%
Negative	0
Negative (%)	0.0%
Memory size	352.0 B

Quantile statistics
Minimum 0
5-th percentile 0
Q1 0
median 0
Q3 0
95-th percentile 0
Maximum 0
Range 0
Interquartile range (IQR) 0

Descriptive statistics
Standard deviation 0
Coefficient of variation (CV) nan
Kurtosis 0
Mean 0
Median Absolute Deviation (MAD) 0
Skewness 0
Sum 0
Variance 0
Monotonicity Increasing

Histogram with fixed size bins (bins=1)

Value	Count	Frequency (%)
0	28	100.0%

Value	Count	Frequency (%)
0	28	100.0%

Value	Count	Frequency (%)
0	28	100.0%

payment_method
Text

Constant Missing

Distinct	1
Distinct (%)	50.0%
Missing	26
Missing (%)	92.9%
Memory size	1.1 KiB

Length
Max length 5
Median length 5
Mean length 5
Min length 5

Characters and Unicode
Total characters 10
Distinct characters 5
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row Check
2nd row Check

Value	Count	Frequency (%)
check	2	100.0%

Most occurring characters

Value	Count	Frequency (%)
C	2	20.0%
h	2	20.0%
e	2	20.0%
c	2	20.0%
k	2	20.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	10	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
C	2	20.0%
h	2	20.0%
e	2	20.0%
c	2	20.0%
k	2	20.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	10	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
C	2	20.0%
h	2	20.0%
e	2	20.0%
c	2	20.0%
k	2	20.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	10	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
C	2	20.0%
h	2	20.0%
e	2	20.0%
c	2	20.0%
k	2	20.0%

notes
Text

Missing

Distinct	14
Distinct (%)	87.5%
Missing	12
Missing (%)	42.9%
Memory size	2.0 KiB

Length
Max length 37
Median length 37
Mean length 37
Min length 37

Characters and Unicode
Total characters 592
Distinct characters 27
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 12 ?
Unique (%) 75.0%

Sample
1st row Purchase generated based on Order #30
2nd row Purchase generated based on Order #33
3rd row Purchase generated based on Order #36
4th row Purchase generated based on Order #38
5th row Purchase generated based on Order #39

Value	Count	Frequency (%)
purchase	16	16.7%
generated	16	16.7%
based	16	16.7%
on	16	16.7%
order	16	16.7%
48	2	2.1%
46	2	2.1%
36	1	1.0%
38	1	1.0%
30	1	1.0%
Other values (9)	9	9.4%

Most occurring characters

Value	Count	Frequency (%)
e	96	16.2%
	80	13.5%
r	64	10.8%
a	48	8.1%
d	48	8.1%
n	32	5.4%
s	32	5.4%
u	16	2.7%
h	16	2.7%
c	16	2.7%
Other values (17)	144	24.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	592	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	96	16.2%
	80	13.5%
r	64	10.8%
a	48	8.1%
d	48	8.1%
n	32	5.4%
s	32	5.4%
u	16	2.7%
h	16	2.7%
c	16	2.7%
Other values (17)	144	24.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	592	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	96	16.2%
	80	13.5%
r	64	10.8%
a	48	8.1%
d	48	8.1%
n	32	5.4%
s	32	5.4%
u	16	2.7%
h	16	2.7%
c	16	2.7%
Other values (17)	144	24.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	592	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	96	16.2%
	80	13.5%
r	64	10.8%
a	48	8.1%
d	48	8.1%
n	32	5.4%
s	32	5.4%
u	16	2.7%
h	16	2.7%
c	16	2.7%
Other values (17)	144	24.3%

approved_by
Real number (ℝ)

Constant Missing

Distinct	1
Distinct (%)	4.0%
Missing	3
Missing (%)	10.7%
Infinite	0
Infinite (%)	0.0%
Mean	2

Minimum	2
Maximum	2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	380.0 B

Quantile statistics
Minimum 2
5-th percentile 2
Q1 2
median 2
Q3 2
95-th percentile 2
Maximum 2
Range 0
Interquartile range (IQR) 0

Descriptive statistics
Standard deviation 0
Coefficient of variation (CV) 0
Kurtosis 0
Mean 2
Median Absolute Deviation (MAD) 0
Skewness 0
Sum 50
Variance 0
Monotonicity Increasing

Histogram with fixed size bins (bins=1)

Value	Count	Frequency (%)
2	25	89.3%
(Missing)	3	10.7%

Value	Count	Frequency (%)
2	25	89.3%

Value	Count	Frequency (%)
2	25	89.3%

approved_date
Date

Missing

Distinct	5
Distinct (%)	20.0%
Missing	3
Missing (%)	10.7%
Memory size	352.0 B

Minimum	2006-01-22 00:00:00
Maximum	2006-04-25 17:18:51
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=5)

submitted_by
Real number (ℝ)

Distinct	8
Distinct (%)	28.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.214285714

Minimum	1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	380.0 B

Quantile statistics
Minimum 1
5-th percentile 1
Q1 2
median 2
Q3 4
95-th percentile 7
Maximum 9
Range 8
Interquartile range (IQR) 2

Descriptive statistics
Standard deviation 2.149196971
Coefficient of variation (CV) 0.6686390576
Kurtosis 0.7791433734
Mean 3.214285714
Median Absolute Deviation (MAD) 0.5
Skewness 1.316046446
Sum 90
Variance 4.619047619
Monotonicity Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
2	14	50.0%
7	3	10.7%
4	3	10.7%
1	3	10.7%
3	2	7.1%
5	1	3.6%
9	1	3.6%
6	1	3.6%

Value	Count	Frequency (%)
1	3	10.7%
2	14	50.0%
3	2	7.1%
4	3	10.7%
5	1	3.6%

Value	Count	Frequency (%)
9	1	3.6%
7	3	10.7%
6	1	3.6%
5	1	3.6%
4	3	10.7%

__table_name__
Text

Constant

Distinct	1
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Memory size	2.1 KiB

Length
Max length 15
Median length 15
Mean length 15
Min length 15

Characters and Unicode
Total characters 420
Distinct characters 11
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row purchase_orders
2nd row purchase_orders
3rd row purchase_orders
4th row purchase_orders
5th row purchase_orders

Value	Count	Frequency (%)
purchase_orders	28	100.0%

Most occurring characters

Value	Count	Frequency (%)
r	84	20.0%
e	56	13.3%
s	56	13.3%
u	28	6.7%
p	28	6.7%
h	28	6.7%
c	28	6.7%
a	28	6.7%
_	28	6.7%
o	28	6.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	420	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	84	20.0%
e	56	13.3%
s	56	13.3%
u	28	6.7%
p	28	6.7%
h	28	6.7%
c	28	6.7%
a	28	6.7%
_	28	6.7%
o	28	6.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	420	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	84	20.0%
e	56	13.3%
s	56	13.3%
u	28	6.7%
p	28	6.7%
h	28	6.7%
c	28	6.7%
a	28	6.7%
_	28	6.7%
o	28	6.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	420	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	84	20.0%
e	56	13.3%
s	56	13.3%
u	28	6.7%
p	28	6.7%
h	28	6.7%
c	28	6.7%
a	28	6.7%
_	28	6.7%
o	28	6.7%

Table: sales_reports

Profile: sales_reports

Overview

Brought to you by YData

Dataset statistics
Number of variables 6
Number of observations 5
Missing cells 0
Missing cells (%) 0.0%
Total size in memory 2.5 KiB
Average record size in memory 502.8 B

Variable types
Text 6

Alerts

`__table_name__` has constant value "sales_reports"	Constant
`group_by` has unique values	Unique
`display` has unique values	Unique
`title` has unique values	Unique
`filter_row_source` has unique values	Unique

Reproduction
Analysis started 2025-10-30 16:47:53.189634
Analysis finished 2025-10-30 16:47:53.273064
Duration 0.08 seconds
Software version ydata-profiling vv4.17.0
Download configuration config.json

group_by
Text

Unique

Distinct	5
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	467.0 B

Length
Max length 14
Median length 11
Mean length 10.8
Min length 8

Characters and Unicode
Total characters 54
Distinct characters 22
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 5 ?
Unique (%) 100.0%

Sample
1st row country_region
2nd row Customer ID
3rd row employee_id
4th row Category
5th row Product ID

Value	Count	Frequency (%)
id	2	28.6%
country_region	1	14.3%
customer	1	14.3%
employee_id	1	14.3%
category	1	14.3%
product	1	14.3%

Most occurring characters

Value	Count	Frequency (%)
o	6	11.1%
e	6	11.1%
r	5	9.3%
t	4	7.4%
y	3	5.6%
u	3	5.6%
n	2	3.7%
c	2	3.7%
_	2	3.7%
g	2	3.7%
Other values (12)	19	35.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	54	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	6	11.1%
e	6	11.1%
r	5	9.3%
t	4	7.4%
y	3	5.6%
u	3	5.6%
n	2	3.7%
c	2	3.7%
_	2	3.7%
g	2	3.7%
Other values (12)	19	35.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	54	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	6	11.1%
e	6	11.1%
r	5	9.3%
t	4	7.4%
y	3	5.6%
u	3	5.6%
n	2	3.7%
c	2	3.7%
_	2	3.7%
g	2	3.7%
Other values (12)	19	35.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	54	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	6	11.1%
e	6	11.1%
r	5	9.3%
t	4	7.4%
y	3	5.6%
u	3	5.6%
n	2	3.7%
c	2	3.7%
_	2	3.7%
g	2	3.7%
Other values (12)	19	35.2%

display
Text

Unique

Distinct	5
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	458.0 B

Length
Max length 14
Median length 8
Mean length 9
Min length 7

Characters and Unicode
Total characters 45
Distinct characters 21
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 5 ?
Unique (%) 100.0%

Sample
1st row Country/Region
2nd row Customer
3rd row Employee
4th row Category
5th row Product

Value	Count	Frequency (%)
country/region	1	20.0%
customer	1	20.0%
employee	1	20.0%
category	1	20.0%
product	1	20.0%

Most occurring characters

Value	Count	Frequency (%)
o	6	13.3%
e	5	11.1%
t	4	8.9%
r	4	8.9%
C	3	6.7%
y	3	6.7%
u	3	6.7%
n	2	4.4%
g	2	4.4%
m	2	4.4%
Other values (11)	11	24.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	45	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	6	13.3%
e	5	11.1%
t	4	8.9%
r	4	8.9%
C	3	6.7%
y	3	6.7%
u	3	6.7%
n	2	4.4%
g	2	4.4%
m	2	4.4%
Other values (11)	11	24.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	45	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	6	13.3%
e	5	11.1%
t	4	8.9%
r	4	8.9%
C	3	6.7%
y	3	6.7%
u	3	6.7%
n	2	4.4%
g	2	4.4%
m	2	4.4%
Other values (11)	11	24.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	45	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	6	13.3%
e	5	11.1%
t	4	8.9%
r	4	8.9%
C	3	6.7%
y	3	6.7%
u	3	6.7%
n	2	4.4%
g	2	4.4%
m	2	4.4%
Other values (11)	11	24.4%

title
Text

Unique

Distinct	5
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	496.0 B

Length
Max length 17
Median length 17
Mean length 16.6
Min length 16

Characters and Unicode
Total characters 83
Distinct characters 22
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 5 ?
Unique (%) 100.0%

Sample
1st row Sales By Country
2nd row Sales By Customer
3rd row Sales By Employee
4th row Sales By Category
5th row Sales by Product

Value	Count	Frequency (%)
sales	5	33.3%
by	5	33.3%
country	1	6.7%
customer	1	6.7%
employee	1	6.7%
category	1	6.7%
product	1	6.7%

Most occurring characters

Value	Count	Frequency (%)
	10	12.0%
e	9	10.8%
y	8	9.6%
l	6	7.2%
s	6	7.2%
a	6	7.2%
S	5	6.0%
o	5	6.0%
B	4	4.8%
r	4	4.8%
Other values (12)	20	24.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	83	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	10	12.0%
e	9	10.8%
y	8	9.6%
l	6	7.2%
s	6	7.2%
a	6	7.2%
S	5	6.0%
o	5	6.0%
B	4	4.8%
r	4	4.8%
Other values (12)	20	24.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	83	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	10	12.0%
e	9	10.8%
y	8	9.6%
l	6	7.2%
s	6	7.2%
a	6	7.2%
S	5	6.0%
o	5	6.0%
B	4	4.8%
r	4	4.8%
Other values (12)	20	24.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	83	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	10	12.0%
e	9	10.8%
y	8	9.6%
l	6	7.2%
s	6	7.2%
a	6	7.2%
S	5	6.0%
o	5	6.0%
B	4	4.8%
r	4	4.8%
Other values (12)	20	24.1%

filter_row_source
Text

Unique

Distinct	5
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	837.0 B

Length
Max length 100
Median length 85
Mean length 84.8
Min length 71

Characters and Unicode
Total characters 424
Distinct characters 41
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 5 ?
Unique (%) 100.0%

Sample
1st row SELECT DISTINCT [country_region] FROM [customers Extended] ORDER BY [country_region];
2nd row SELECT DISTINCT [Company] FROM [customers Extended] ORDER BY [Company];
3rd row SELECT DISTINCT [Employee Name] FROM [`dl_northwind`.`employees` Extended] ORDER BY [Employee Name];
4th row SELECT DISTINCT [Category] FROM [`dl_northwind`.`products`] ORDER BY [Category];
5th row SELECT DISTINCT [Product Name] FROM [`dl_northwind`.`products`] ORDER BY [Product Name];

Value	Count	Frequency (%)
select	5	10.6%
distinct	5	10.6%
from	5	10.6%
order	5	10.6%
by	5	10.6%
name	4	8.5%
extended	3	6.4%
customers	2	4.3%
country_region	2	4.3%
company	2	4.3%
Other values (5)	9	19.1%

Most occurring characters

Value	Count	Frequency (%)
	42	9.9%
e	23	5.4%
E	20	4.7%
o	20	4.7%
t	16	3.8%
d	16	3.8%
T	15	3.5%
R	15	3.5%
r	15	3.5%
[	15	3.5%
Other values (31)	227	53.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	424	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	42	9.9%
e	23	5.4%
E	20	4.7%
o	20	4.7%
t	16	3.8%
d	16	3.8%
T	15	3.5%
R	15	3.5%
r	15	3.5%
[	15	3.5%
Other values (31)	227	53.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	424	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	42	9.9%
e	23	5.4%
E	20	4.7%
o	20	4.7%
t	16	3.8%
d	16	3.8%
T	15	3.5%
R	15	3.5%
r	15	3.5%
[	15	3.5%
Other values (31)	227	53.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	424	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	42	9.9%
e	23	5.4%
E	20	4.7%
o	20	4.7%
t	16	3.8%
d	16	3.8%
T	15	3.5%
R	15	3.5%
r	15	3.5%
[	15	3.5%
Other values (31)	227	53.5%

default
Text

Distinct	2
Distinct (%)	40.0%
Missing	0
Missing (%)	0.0%
Memory size	418.0 B

Length
Max length 1
Median length 1
Mean length 1
Min length 1

Characters and Unicode
Total characters 5
Distinct characters 2
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 1 ?
Unique (%) 20.0%

Sample
1st row 0
2nd row 0
3rd row 0
4th row 0
5th row 1

Value	Count	Frequency (%)
0	4	80.0%
1	1	20.0%

Most occurring characters

Value	Count	Frequency (%)
0	4	80.0%
1	1	20.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	4	80.0%
1	1	20.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	4	80.0%
1	1	20.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	4	80.0%
1	1	20.0%

__table_name__
Text

Constant

Distinct	1
Distinct (%)	20.0%
Missing	0
Missing (%)	0.0%
Memory size	478.0 B

Length
Max length 13
Median length 13
Mean length 13
Min length 13

Characters and Unicode
Total characters 65
Distinct characters 9
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row sales_reports
2nd row sales_reports
3rd row sales_reports
4th row sales_reports
5th row sales_reports

Value	Count	Frequency (%)
sales_reports	5	100.0%

Most occurring characters

Value	Count	Frequency (%)
s	15	23.1%
e	10	15.4%
r	10	15.4%
l	5	7.7%
a	5	7.7%
_	5	7.7%
p	5	7.7%
o	5	7.7%
t	5	7.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	65	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
s	15	23.1%
e	10	15.4%
r	10	15.4%
l	5	7.7%
a	5	7.7%
_	5	7.7%
p	5	7.7%
o	5	7.7%
t	5	7.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	65	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
s	15	23.1%
e	10	15.4%
r	10	15.4%
l	5	7.7%
a	5	7.7%
_	5	7.7%
p	5	7.7%
o	5	7.7%
t	5	7.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	65	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
s	15	23.1%
e	10	15.4%
r	10	15.4%
l	5	7.7%
a	5	7.7%
_	5	7.7%
p	5	7.7%
o	5	7.7%
t	5	7.7%

Table: shippers

Profile: shippers

Overview

Brought to you by YData

Dataset statistics
Number of variables 19
Number of observations 3
Missing cells 30
Missing cells (%) 52.6%
Total size in memory 2.4 KiB
Average record size in memory 804.7 B

Variable types
Numeric 1
Text 8
Unsupported 10

Alerts

`address` has constant value "123 Any Street"	Constant
`city` has constant value "Memphis"	Constant
`state_province` has constant value "TN"	Constant
`zip_postal_code` has constant value "99999"	Constant
`country_region` has constant value "USA"	Constant
`attachments` has constant value ""	Constant
`__table_name__` has constant value "shippers"	Constant
`last_name` has 3 (100.0%) missing values	Missing
`first_name` has 3 (100.0%) missing values	Missing
`email_address` has 3 (100.0%) missing values	Missing
`job_title` has 3 (100.0%) missing values	Missing
`business_phone` has 3 (100.0%) missing values	Missing
`home_phone` has 3 (100.0%) missing values	Missing
`mobile_phone` has 3 (100.0%) missing values	Missing
`fax_number` has 3 (100.0%) missing values	Missing
`web_page` has 3 (100.0%) missing values	Missing
`notes` has 3 (100.0%) missing values	Missing
`id` has unique values	Unique
`company` has unique values	Unique
`last_name` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`first_name` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`email_address` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`job_title` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`business_phone` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`home_phone` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mobile_phone` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`fax_number` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`web_page` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`notes` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction
Analysis started 2025-10-30 16:47:55.658889
Analysis finished 2025-10-30 16:47:55.790519
Duration 0.13 seconds
Software version ydata-profiling vv4.17.0
Download configuration config.json

id
Real number (ℝ)

Unique

Distinct	3
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2

Minimum	1
Maximum	3
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	155.0 B

Quantile statistics
Minimum 1
5-th percentile 1.1
Q1 1.5
median 2
Q3 2.5
95-th percentile 2.9
Maximum 3
Range 2
Interquartile range (IQR) 1

Descriptive statistics
Histogram with fixed size bins (bins=3)
Standard deviation 1
Coefficient of variation (CV) 0.5
Kurtosis
Mean 2

Median Absolute Deviation (MAD) 1

Skewness 0

Sum 6

Variance 1

Monotonicity Strictly increasing

Value Count Frequency (%)
1 1
33.3%
2 1
33.3%
3 1
33.3%

Value	Count	Frequency (%)
1	1	33.3%
2	1	33.3%
3	1	33.3%

Value	Count	Frequency (%)
3	1	33.3%
2	1	33.3%
1	1	33.3%

company
Text

Unique

Distinct	3
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	353.0 B

Length
Max length 18
Median length 18
Mean length 18
Min length 18

Characters and Unicode
Total characters 54
Distinct characters 14
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 3 ?
Unique (%) 100.0%

Sample
1st row Shipping Company A
2nd row Shipping Company B
3rd row Shipping Company C

Value	Count	Frequency (%)
shipping	3	33.3%
company	3	33.3%
a	1	11.1%
b	1	11.1%
c	1	11.1%

Most occurring characters

Value	Count	Frequency (%)
p	9	16.7%
i	6	11.1%
n	6	11.1%
	6	11.1%
C	4	7.4%
S	3	5.6%
g	3	5.6%
h	3	5.6%
o	3	5.6%
m	3	5.6%
Other values (4)	8	14.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	54	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
p	9	16.7%
i	6	11.1%
n	6	11.1%
	6	11.1%
C	4	7.4%
S	3	5.6%
g	3	5.6%
h	3	5.6%
o	3	5.6%
m	3	5.6%
Other values (4)	8	14.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	54	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
p	9	16.7%
i	6	11.1%
n	6	11.1%
	6	11.1%
C	4	7.4%
S	3	5.6%
g	3	5.6%
h	3	5.6%
o	3	5.6%
m	3	5.6%
Other values (4)	8	14.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	54	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
p	9	16.7%
i	6	11.1%
n	6	11.1%
	6	11.1%
C	4	7.4%
S	3	5.6%
g	3	5.6%
h	3	5.6%
o	3	5.6%
m	3	5.6%
Other values (4)	8	14.8%

last_name
Unsupported

Missing Rejected Unsupported

Missing	3
Missing (%)	100.0%
Memory size	152.0 B

first_name
Unsupported

Missing Rejected Unsupported

Missing	3
Missing (%)	100.0%
Memory size	152.0 B

email_address
Unsupported

Missing Rejected Unsupported

Missing	3
Missing (%)	100.0%
Memory size	152.0 B

job_title
Unsupported

Missing Rejected Unsupported

Missing	3
Missing (%)	100.0%
Memory size	152.0 B

business_phone
Unsupported

Missing Rejected Unsupported

Missing	3
Missing (%)	100.0%
Memory size	152.0 B

home_phone
Unsupported

Missing Rejected Unsupported

Missing	3
Missing (%)	100.0%
Memory size	152.0 B

mobile_phone
Unsupported

Missing Rejected Unsupported

Missing	3
Missing (%)	100.0%
Memory size	152.0 B

fax_number
Unsupported

Missing Rejected Unsupported

Missing	3
Missing (%)	100.0%
Memory size	152.0 B

address
Text

Constant

Distinct	1
Distinct (%)	33.3%
Missing	0
Missing (%)	0.0%
Memory size	341.0 B

Length
Max length 14
Median length 14
Mean length 14
Min length 14

Characters and Unicode
Total characters 42
Distinct characters 11
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row 123 Any Street
2nd row 123 Any Street
3rd row 123 Any Street

Value	Count	Frequency (%)
123	3	33.3%
any	3	33.3%
street	3	33.3%

Most occurring characters

Value	Count	Frequency (%)
e	6	14.3%
t	6	14.3%
	6	14.3%
3	3	7.1%
2	3	7.1%
1	3	7.1%
A	3	7.1%
y	3	7.1%
n	3	7.1%
S	3	7.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	42	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	6	14.3%
t	6	14.3%
	6	14.3%
3	3	7.1%
2	3	7.1%
1	3	7.1%
A	3	7.1%
y	3	7.1%
n	3	7.1%
S	3	7.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	42	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	6	14.3%
t	6	14.3%
	6	14.3%
3	3	7.1%
2	3	7.1%
1	3	7.1%
A	3	7.1%
y	3	7.1%
n	3	7.1%
S	3	7.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	42	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	6	14.3%
t	6	14.3%
	6	14.3%
3	3	7.1%
2	3	7.1%
1	3	7.1%
A	3	7.1%
y	3	7.1%
n	3	7.1%
S	3	7.1%

city
Text

Constant

Distinct	1
Distinct (%)	33.3%
Missing	0
Missing (%)	0.0%
Memory size	320.0 B

Length
Max length 7
Median length 7
Mean length 7
Min length 7

Characters and Unicode
Total characters 21
Distinct characters 7
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row Memphis
2nd row Memphis
3rd row Memphis

Value	Count	Frequency (%)
memphis	3	100.0%

Most occurring characters

Value	Count	Frequency (%)
M	3	14.3%
e	3	14.3%
m	3	14.3%
p	3	14.3%
h	3	14.3%
i	3	14.3%
s	3	14.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
M	3	14.3%
e	3	14.3%
m	3	14.3%
p	3	14.3%
h	3	14.3%
i	3	14.3%
s	3	14.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
M	3	14.3%
e	3	14.3%
m	3	14.3%
p	3	14.3%
h	3	14.3%
i	3	14.3%
s	3	14.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
M	3	14.3%
e	3	14.3%
m	3	14.3%
p	3	14.3%
h	3	14.3%
i	3	14.3%
s	3	14.3%

state_province
Text

Constant

Distinct	1
Distinct (%)	33.3%
Missing	0
Missing (%)	0.0%
Memory size	305.0 B

Length
Max length 2
Median length 2
Mean length 2
Min length 2

Characters and Unicode
Total characters 6
Distinct characters 2
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row TN
2nd row TN
3rd row TN

Value	Count	Frequency (%)
tn	3	100.0%

Most occurring characters

Value	Count	Frequency (%)
T	3	50.0%
N	3	50.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
T	3	50.0%
N	3	50.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
T	3	50.0%
N	3	50.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
T	3	50.0%
N	3	50.0%

zip_postal_code
Text

Constant

Distinct	1
Distinct (%)	33.3%
Missing	0
Missing (%)	0.0%
Memory size	314.0 B

Length
Max length 5
Median length 5
Mean length 5
Min length 5

Characters and Unicode
Total characters 15
Distinct characters 1
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row 99999
2nd row 99999
3rd row 99999

Value	Count	Frequency (%)
99999	3	100.0%

Most occurring characters

Value	Count	Frequency (%)
9	15	100.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	15	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
9	15	100.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	15	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
9	15	100.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	15	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
9	15	100.0%

country_region
Text

Constant

Distinct	1
Distinct (%)	33.3%
Missing	0
Missing (%)	0.0%
Memory size	308.0 B

Length
Max length 3
Median length 3
Mean length 3
Min length 3

Characters and Unicode
Total characters 9
Distinct characters 3
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row USA
2nd row USA
3rd row USA

Value	Count	Frequency (%)
usa	3	100.0%

Most occurring characters

Value	Count	Frequency (%)
U	3	33.3%
S	3	33.3%
A	3	33.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	9	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
U	3	33.3%
S	3	33.3%
A	3	33.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	9	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
U	3	33.3%
S	3	33.3%
A	3	33.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	9	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
U	3	33.3%
S	3	33.3%
A	3	33.3%

web_page
Unsupported

Missing Rejected Unsupported

Missing	3
Missing (%)	100.0%
Memory size	152.0 B

notes
Unsupported

Missing Rejected Unsupported

Missing	3
Missing (%)	100.0%
Memory size	152.0 B

attachments
Text

Constant

Distinct	1
Distinct (%)	33.3%
Missing	0
Missing (%)	0.0%
Memory size	299.0 B

Length
Max length 0
Median length 0
Mean length 0
Min length 0

Characters and Unicode
Total characters 0
Distinct characters 0
Distinct categories 0 ?
Distinct scripts 0 ?
Distinct blocks 0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row
2nd row
3rd row

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

__table_name__
Text

Constant

Distinct	1
Distinct (%)	33.3%
Missing	0
Missing (%)	0.0%
Memory size	323.0 B

Length
Max length 8
Median length 8
Mean length 8
Min length 8

Characters and Unicode
Total characters 24
Distinct characters 6
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row shippers
2nd row shippers
3rd row shippers

Value	Count	Frequency (%)
shippers	3	100.0%

Most occurring characters

Value	Count	Frequency (%)
s	6	25.0%
p	6	25.0%
h	3	12.5%
i	3	12.5%
e	3	12.5%
r	3	12.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	24	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
s	6	25.0%
p	6	25.0%
h	3	12.5%
i	3	12.5%
e	3	12.5%
r	3	12.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	24	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
s	6	25.0%
p	6	25.0%
h	3	12.5%
i	3	12.5%
e	3	12.5%
r	3	12.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	24	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
s	6	25.0%
p	6	25.0%
h	3	12.5%
i	3	12.5%
e	3	12.5%
r	3	12.5%

Table: strings

Profile: strings

Overview

Brought to you by YData

Dataset statistics
Number of variables 3
Number of observations 62
Missing cells 0
Missing cells (%) 0.0%
Total size in memory 11.3 KiB
Average record size in memory 186.9 B

Variable types
Numeric 1
Text 2

Alerts

`__table_name__` has constant value "strings"	Constant
`string_id` has unique values	Unique
`string_data` has unique values	Unique

Reproduction
Analysis started 2025-10-30 16:47:58.932528
Analysis finished 2025-10-30 16:47:58.969345
Duration 0.04 seconds
Software version ydata-profiling vv4.17.0
Download configuration config.json

string_id
Real number (ℝ)

Unique

Distinct	62
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	45.30645161

Minimum	2
Maximum	114
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	686.0 B

Quantile statistics
Minimum 2
5-th percentile 5.05
Q1 17.25
median 33.5
Q3 48.75
95-th percentile 110.95
Maximum 114
Range 112
Interquartile range (IQR) 31.5

Descriptive statistics
Standard deviation 37.27900508
Coefficient of variation (CV) 0.8228189089
Kurtosis -0.7600780365
Mean 45.30645161
Median Absolute Deviation (MAD) 16
Skewness 0.872987198
Sum 2809
Variance 1389.72422
Monotonicity Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	1	1.6%
6	1	1.6%
3	1	1.6%
10	1	1.6%
5	1	1.6%
7	1	1.6%
8	1	1.6%
9	1	1.6%
2	1	1.6%
46	1	1.6%
Other values (52)	52	83.9%

Value	Count	Frequency (%)
2	1	1.6%
3	1	1.6%
4	1	1.6%
5	1	1.6%
6	1	1.6%

Value	Count	Frequency (%)
114	1	1.6%
113	1	1.6%
112	1	1.6%
111	1	1.6%
110	1	1.6%

string_data
Text

Unique

Distinct	62
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	6.9 KiB

Length
Max length 149
Median length 73
Mean length 54.82258065
Min length 17

Characters and Unicode
Total characters 3399
Distinct characters 51
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 62 ?
Unique (%) 100.0%

Sample
1st row Back ordered product filled for Order #|
2nd row Insufficient inventory.
3rd row Cannot remove posted inventory!
4th row Must specify customer name!
5th row Discounted price below cost!

Value	Count	Frequency (%)
to	23	4.6%
order	21	4.2%
inventory	17	3.4%
purchase	17	3.4%
you	16	3.2%
product	15	3.0%
cannot	13	2.6%
for	11	2.2%
must	10	2.0%
successfully	10	2.0%
Other values (147)	350	69.6%

Most occurring characters

Value	Count	Frequency (%)
	451	13.3%
e	343	10.1%
r	257	7.6%
o	249	7.3%
t	222	6.5%
n	194	5.7%
s	179	5.3%
i	166	4.9%
d	148	4.4%
a	147	4.3%
Other values (41)	1043	30.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3399	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	451	13.3%
e	343	10.1%
r	257	7.6%
o	249	7.3%
t	222	6.5%
n	194	5.7%
s	179	5.3%
i	166	4.9%
d	148	4.4%
a	147	4.3%
Other values (41)	1043	30.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3399	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	451	13.3%
e	343	10.1%
r	257	7.6%
o	249	7.3%
t	222	6.5%
n	194	5.7%
s	179	5.3%
i	166	4.9%
d	148	4.4%
a	147	4.3%
Other values (41)	1043	30.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3399	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	451	13.3%
e	343	10.1%
r	257	7.6%
o	249	7.3%
t	222	6.5%
n	194	5.7%
s	179	5.3%
i	166	4.9%
d	148	4.4%
a	147	4.3%
Other values (41)	1043	30.7%

__table_name__
Text

Constant

Distinct	1
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

Length
Max length 7
Median length 7
Mean length 7
Min length 7

Characters and Unicode
Total characters 434
Distinct characters 6
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row strings
2nd row strings
3rd row strings
4th row strings
5th row strings

Value	Count	Frequency (%)
strings	62	100.0%

Most occurring characters

Value	Count	Frequency (%)
s	124	28.6%
t	62	14.3%
r	62	14.3%
i	62	14.3%
n	62	14.3%
g	62	14.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	434	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
s	124	28.6%
t	62	14.3%
r	62	14.3%
i	62	14.3%
n	62	14.3%
g	62	14.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	434	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
s	124	28.6%
t	62	14.3%
r	62	14.3%
i	62	14.3%
n	62	14.3%
g	62	14.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	434	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
s	124	28.6%
t	62	14.3%
r	62	14.3%
i	62	14.3%
n	62	14.3%
g	62	14.3%

Table: suppliers

Profile: suppliers

Overview

Brought to you by YData

Dataset statistics
Number of variables 19
Number of observations 10
Missing cells 120
Missing cells (%) 63.2%
Total size in memory 6.8 KiB
Average record size in memory 701.4 B

Variable types
Numeric 1
Text 6
Unsupported 12

Alerts

`attachments` has constant value ""	Constant
`__table_name__` has constant value "suppliers"	Constant
`email_address` has 10 (100.0%) missing values	Missing
`business_phone` has 10 (100.0%) missing values	Missing
`home_phone` has 10 (100.0%) missing values	Missing
`mobile_phone` has 10 (100.0%) missing values	Missing
`fax_number` has 10 (100.0%) missing values	Missing
`address` has 10 (100.0%) missing values	Missing
`city` has 10 (100.0%) missing values	Missing
`state_province` has 10 (100.0%) missing values	Missing
`zip_postal_code` has 10 (100.0%) missing values	Missing
`country_region` has 10 (100.0%) missing values	Missing
`web_page` has 10 (100.0%) missing values	Missing
`notes` has 10 (100.0%) missing values	Missing
`id` has unique values	Unique
`company` has unique values	Unique
`last_name` has unique values	Unique
`first_name` has unique values	Unique
`email_address` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`business_phone` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`home_phone` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mobile_phone` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`fax_number` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`address` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`city` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`state_province` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`zip_postal_code` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`country_region` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`web_page` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`notes` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction
Analysis started 2025-10-30 16:48:01.007539
Analysis finished 2025-10-30 16:48:01.151209
Duration 0.14 seconds
Software version ydata-profiling vv4.17.0
Download configuration config.json

id
Real number (ℝ)

Unique

Distinct	10
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.5

Minimum	1
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	218.0 B

Quantile statistics
Minimum 1
5-th percentile 1.45
Q1 3.25
median 5.5
Q3 7.75
95-th percentile 9.55
Maximum 10
Range 9
Interquartile range (IQR) 4.5

Descriptive statistics
Standard deviation 3.027650354
Coefficient of variation (CV) 0.5504818826
Kurtosis -1.2
Mean 5.5
Median Absolute Deviation (MAD) 2.5
Skewness 0
Sum 55
Variance 9.166666667
Monotonicity Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
6	1	10.0%
4	1	10.0%
7	1	10.0%
2	1	10.0%
1	1	10.0%
5	1	10.0%
9	1	10.0%
10	1	10.0%
3	1	10.0%
8	1	10.0%

Value	Count	Frequency (%)
1	1	10.0%
2	1	10.0%
3	1	10.0%
4	1	10.0%
5	1	10.0%

Value	Count	Frequency (%)
10	1	10.0%
9	1	10.0%
8	1	10.0%
7	1	10.0%
6	1	10.0%

company
Text

Unique

Distinct	10
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	798.0 B

Length
Max length 10
Median length 10
Mean length 10
Min length 10

Characters and Unicode
Total characters 100
Distinct characters 18
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 10 ?
Unique (%) 100.0%

Sample
1st row Supplier F
2nd row Supplier D
3rd row Supplier G
4th row Supplier B
5th row Supplier A

Value	Count	Frequency (%)
supplier	10	50.0%
f	1	5.0%
d	1	5.0%
g	1	5.0%
b	1	5.0%
a	1	5.0%
e	1	5.0%
i	1	5.0%
j	1	5.0%
c	1	5.0%

Most occurring characters

Value	Count	Frequency (%)
p	20	20.0%
S	10	10.0%
u	10	10.0%
l	10	10.0%
i	10	10.0%
e	10	10.0%
r	10	10.0%
	10	10.0%
F	1	1.0%
D	1	1.0%
Other values (8)	8	8.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	100	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
p	20	20.0%
S	10	10.0%
u	10	10.0%
l	10	10.0%
i	10	10.0%
e	10	10.0%
r	10	10.0%
	10	10.0%
F	1	1.0%
D	1	1.0%
Other values (8)	8	8.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	100	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
p	20	20.0%
S	10	10.0%
u	10	10.0%
l	10	10.0%
i	10	10.0%
e	10	10.0%
r	10	10.0%
	10	10.0%
F	1	1.0%
D	1	1.0%
Other values (8)	8	8.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	100	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
p	20	20.0%
S	10	10.0%
u	10	10.0%
l	10	10.0%
i	10	10.0%
e	10	10.0%
r	10	10.0%
	10	10.0%
F	1	1.0%
D	1	1.0%
Other values (8)	8	8.0%

last_name
Text

Unique

Distinct	10
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	776.0 B

Length
Max length 20
Median length 8
Mean length 7.8
Min length 4

Characters and Unicode
Total characters 78
Distinct characters 29
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 10 ?
Unique (%) 100.0%

Sample
1st row Hayakawa
2nd row Sato
3rd row Glasson
4th row Weiler
5th row Andersen

Value	Count	Frequency (%)
hayakawa	1	10.0%
sato	1	10.0%
glasson	1	10.0%
weiler	1	10.0%
andersen	1	10.0%
hernandez-echevarria	1	10.0%
sandberg	1	10.0%
sousa	1	10.0%
kelley	1	10.0%
dunton	1	10.0%

Most occurring characters

Value	Count	Frequency (%)
a	11	14.1%
e	10	12.8%
n	8	10.3%
r	6	7.7%
s	4	5.1%
o	4	5.1%
l	4	5.1%
S	3	3.8%
d	3	3.8%
i	2	2.6%
Other values (19)	23	29.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	78	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	11	14.1%
e	10	12.8%
n	8	10.3%
r	6	7.7%
s	4	5.1%
o	4	5.1%
l	4	5.1%
S	3	3.8%
d	3	3.8%
i	2	2.6%
Other values (19)	23	29.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	78	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	11	14.1%
e	10	12.8%
n	8	10.3%
r	6	7.7%
s	4	5.1%
o	4	5.1%
l	4	5.1%
S	3	3.8%
d	3	3.8%
i	2	2.6%
Other values (19)	23	29.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	78	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	11	14.1%
e	10	12.8%
n	8	10.3%
r	6	7.7%
s	4	5.1%
o	4	5.1%
l	4	5.1%
S	3	3.8%
d	3	3.8%
i	2	2.6%
Other values (19)	23	29.5%

first_name
Text

Unique

Distinct	10
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	768.0 B

Length
Max length 12
Median length 8.5
Mean length 7
Min length 4

Characters and Unicode
Total characters 70
Distinct characters 28
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 10 ?
Unique (%) 100.0%

Sample
1st row Satomi
2nd row Naoki
3rd row Stuart
4th row Cornelia
5th row Elizabeth A.

Value	Count	Frequency (%)
satomi	1	8.3%
naoki	1	8.3%
stuart	1	8.3%
cornelia	1	8.3%
elizabeth	1	8.3%
a	1	8.3%
amaya	1	8.3%
mikael	1	8.3%
luis	1	8.3%
madeleine	1	8.3%
Other values (2)	2	16.7%

Most occurring characters

Value	Count	Frequency (%)
a	10	14.3%
i	7	10.0%
e	6	8.6%
l	5	7.1%
t	4	5.7%
n	3	4.3%
r	3	4.3%
o	3	4.3%
u	3	4.3%
k	2	2.9%
Other values (18)	24	34.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	70	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	10	14.3%
i	7	10.0%
e	6	8.6%
l	5	7.1%
t	4	5.7%
n	3	4.3%
r	3	4.3%
o	3	4.3%
u	3	4.3%
k	2	2.9%
Other values (18)	24	34.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	70	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	10	14.3%
i	7	10.0%
e	6	8.6%
l	5	7.1%
t	4	5.7%
n	3	4.3%
r	3	4.3%
o	3	4.3%
u	3	4.3%
k	2	2.9%
Other values (18)	24	34.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	70	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	10	14.3%
i	7	10.0%
e	6	8.6%
l	5	7.1%
t	4	5.7%
n	3	4.3%
r	3	4.3%
o	3	4.3%
u	3	4.3%
k	2	2.9%
Other values (18)	24	34.3%

email_address
Unsupported

Missing Rejected Unsupported

Missing	10
Missing (%)	100.0%
Memory size	208.0 B

job_title
Text

Distinct	4
Distinct (%)	40.0%
Missing	0
Missing (%)	0.0%
Memory size	856.0 B

Length
Max length 20
Median length 19.5
Mean length 15.8
Min length 13

Characters and Unicode
Total characters 158
Distinct characters 17
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 1 ?
Unique (%) 10.0%

Sample
1st row Marketing Assistant
2nd row Marketing Manager
3rd row Marketing Manager
4th row Sales Manager
5th row Sales Manager

Value	Count	Frequency (%)
sales	7	35.0%
manager	7	35.0%
marketing	3	15.0%
representative	2	10.0%
assistant	1	5.0%

Most occurring characters

Value	Count	Frequency (%)
a	27	17.1%
e	25	15.8%
n	13	8.2%
r	12	7.6%
s	12	7.6%
g	10	6.3%
M	10	6.3%
	10	6.3%
t	9	5.7%
S	7	4.4%
Other values (7)	23	14.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	158	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	27	17.1%
e	25	15.8%
n	13	8.2%
r	12	7.6%
s	12	7.6%
g	10	6.3%
M	10	6.3%
	10	6.3%
t	9	5.7%
S	7	4.4%
Other values (7)	23	14.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	158	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	27	17.1%
e	25	15.8%
n	13	8.2%
r	12	7.6%
s	12	7.6%
g	10	6.3%
M	10	6.3%
	10	6.3%
t	9	5.7%
S	7	4.4%
Other values (7)	23	14.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	158	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	27	17.1%
e	25	15.8%
n	13	8.2%
r	12	7.6%
s	12	7.6%
g	10	6.3%
M	10	6.3%
	10	6.3%
t	9	5.7%
S	7	4.4%
Other values (7)	23	14.6%

business_phone
Unsupported

Missing Rejected Unsupported

Missing	10
Missing (%)	100.0%
Memory size	208.0 B

home_phone
Unsupported

Missing Rejected Unsupported

Missing	10
Missing (%)	100.0%
Memory size	208.0 B

mobile_phone
Unsupported

Missing Rejected Unsupported

Missing	10
Missing (%)	100.0%
Memory size	208.0 B

fax_number
Unsupported

Missing Rejected Unsupported

Missing	10
Missing (%)	100.0%
Memory size	208.0 B

address
Unsupported

Missing Rejected Unsupported

Missing	10
Missing (%)	100.0%
Memory size	208.0 B

city
Unsupported

Missing Rejected Unsupported

Missing	10
Missing (%)	100.0%
Memory size	208.0 B

state_province
Unsupported

Missing Rejected Unsupported

Missing	10
Missing (%)	100.0%
Memory size	208.0 B

zip_postal_code
Unsupported

Missing Rejected Unsupported

Missing	10
Missing (%)	100.0%
Memory size	208.0 B

country_region
Unsupported

Missing Rejected Unsupported

Missing	10
Missing (%)	100.0%
Memory size	208.0 B

web_page
Unsupported

Missing Rejected Unsupported

Missing	10
Missing (%)	100.0%
Memory size	208.0 B

notes
Unsupported

Missing Rejected Unsupported

Missing	10
Missing (%)	100.0%
Memory size	208.0 B

attachments
Text

Constant

Distinct	1
Distinct (%)	10.0%
Missing	0
Missing (%)	0.0%
Memory size	698.0 B

Length
Max length 0
Median length 0
Mean length 0
Min length 0

Characters and Unicode
Total characters 0
Distinct characters 0
Distinct categories 0 ?
Distinct scripts 0 ?
Distinct blocks 0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row
2nd row
3rd row
4th row
5th row

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

__table_name__
Text

Constant

Distinct	1
Distinct (%)	10.0%
Missing	0
Missing (%)	0.0%
Memory size	788.0 B

Length
Max length 9
Median length 9
Mean length 9
Min length 9

Characters and Unicode
Total characters 90
Distinct characters 7
Distinct categories 1 ?
Distinct scripts 1 ?
Distinct blocks 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique
Unique 0 ?
Unique (%) 0.0%

Sample
1st row suppliers
2nd row suppliers
3rd row suppliers
4th row suppliers
5th row suppliers

Value	Count	Frequency (%)
suppliers	10	100.0%

Most occurring characters

Value	Count	Frequency (%)
s	20	22.2%
p	20	22.2%
u	10	11.1%
l	10	11.1%
i	10	11.1%
e	10	11.1%
r	10	11.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	90	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
s	20	22.2%
p	20	22.2%
u	10	11.1%
l	10	11.1%
i	10	11.1%
e	10	11.1%
r	10	11.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	90	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
s	20	22.2%
p	20	22.2%
u	10	11.1%
l	10	11.1%
i	10	11.1%
e	10	11.1%
r	10	11.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	90	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
s	20	22.2%
p	20	22.2%
u	10	11.1%
l	10	11.1%
i	10	11.1%
e	10	11.1%
r	10	11.1%

Distinct	29
Distinct (%)	96.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.53333333

Distinct	16
Distinct (%)	53.3%
Missing	0
Missing (%)	0.0%
Memory size	2.0 KiB

Summary of All Tables

Table: customer

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script